By using 'force view' we can create a view without base table

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

Question Posted / amedela chandra sekhar

Answer Posted / amedela chandra sekhar

By using 'force view'
we can create a view without base table

Is This Answer Correct ?

14 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the operators used in select statements?

1000

How bulk collect improves performance?

947

what is data integrity? : Sql dba

985

what is commit? : Sql dba

1026

how to enter numeric values as hex numbers? : Sql dba

1006

What are three advantages to using sql?

958

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

1102

What is a sql schema used for?

1027

What is offset and limit in sql?

999

what is innodb? : Sql dba

1033

how can we know the number of days between two given dates using mysql? : Sql dba

991

What do you know by pl/sql cursors?

1034

What is rtm stands for?

1021

How can you save or place your msg in a table?

953

What is record type in pl sql?

936