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 is dialect in sql?

939

What is difference between cursor and trigger?

1063

What are string functions in sql?

1229

Can we alter stored procedure?

979

what is the difference between nested subquery and correlated subquery?

1045

what is the difference between sql and t-sql? : Transact sql

1081

What are the benefits of pl sql?

1110

What is pl sql package?

1029

Explain what is an index?

1049

What is the difference between a query and a report?

962

what are all the different types of indexes? : Sql dba

1042

Does truncate remove indexes?

1020

What is sqlerrm?

927

How delete all data from all tables in sql?

942

what are the authentication modes in sql server? : Sql dba

1056