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 the use of %rowtype?

976

How do I trace sql profiler?

920

What are the two characteristics of a primary key?

926

what is column? : Sql dba

960

How to select unique records from a table?

999

Why we use pl sql?

907

What are field types?

940

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1014

What port does sql server use?

986

What is pl sql code?

992

What does 0 mean in sql?

911

Explain the the update statement in sql?

987

Why triggers are used?

937

What is crud diagram?

877

How to look at the current sql*plus system settings?

1079