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

explain the delete statements in sql

1058

What are the different types of database management systems?

1001

Is sql a backend?

1020

What is trigger explain with example?

1039

what is a constraint? Tell me about its various levels. : Sql dba

986

What is primary key in db?

1007

Why do we use function in pl sql?

1060

Which is faster subquery or join?

1217

How do I write a sql query in pgadmin 4?

982

Why is there a need for sqlcode and sqlerrm variables?

1048

How do I find duplicates in a single column in sql?

1020

What is a composite primary key?

1093

What is meant by truncate in sql?

1068

what is the difference between union and union all? : Sql dba

1020

Is sql open source?

973