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

Answers were Sorted based on User's Feedback



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

Answer / vijayakumar

Using FORCE Command we can create a view without base table.

Is This Answer Correct ?    40 Yes 1 No

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

Answer / amedela chandra sekhar

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

Is This Answer Correct ?    14 Yes 1 No

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

Answer / 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

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

Answer / senthil

sorry, i am not understand..... emp table is not exit meaning?

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is Referential Integrity?

3 Answers   IBM,


difference between anonymous blocks and sub-programs.

1 Answers  


What is sql query optimization?

1 Answers  


How do I create a sql script?

1 Answers  


Why plvtab is considered as the easiest way to access the pl/sql table?

1 Answers  


What are the operators used in select statements?

1 Answers  


wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,


What is sqlite used for?

1 Answers  


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

5 Answers  


is mysql query is case sensitive? : Sql dba

1 Answers  


What are the most important characteristics of pl/sql?

1 Answers  


how to insert the records in particular position

1 Answers  


Categories