Using force command we can create view without table Exa create or re

How to create a view on a table which does not exists

Question Posted / ajmal

Answer Posted / ajmal

Using force command we can create view without table
Exa
create or replace force view aa_vu as select *from emp;

Note:emp table is not exit

Is This Answer Correct ?

12 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are the different type of sql's statements ? : Sql dba

972

What is cross join example?

1061

Does truncate remove indexes?

1073

What is autocommit sql?

1033

Can we insert data into view?

946

Mention what are different methods to trace the pl/sql code?

1288

What is data profiling in sql?

1130

What is procedure and function?

1031

What is compilation error in pl sql?

1020

what is subquery? : Sql dba

1181

What is a primary key sql?

1086

What is sql server and ase?

1066

What is cartesian join in sql?

1186

What is dbo in sql?

1014

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1036