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 a unique constraint?

1056

If a cursor is open, how can we find in a pl/sql block?

1148

Can variables be used in sql statements?

1012

Explain what is a database?

1069

What is a database event trigger?

1130

Why left join is used in sql?

954

How to create an array in pl/sql?

1050

Explain the difference between rename and alias?

998

What is user in sql?

1002

what is the command line end user interface - mysql? : Sql dba

962

What is sql injection vulnerability?

925

Can we use update in sql function?

1042

What are the sql commands?

1135

What is record in pl sql?

1059

Can we call dml statement in function?

1021