1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guntu

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

how to create user in sql and how to set password for that?

3 Answers  

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

Explain architecture of sql server notification services?

0 Answers  

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  




what happens if you no create privilege in a database? : Sql dba

0 Answers  

how to decrement dates by 1 in mysql? : Sql dba

0 Answers  

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  

What is sql indexing?

0 Answers  

How to create your own reports in sql developer?

0 Answers  

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

For more SQL PLSQL Interview Questions Click Here
Categories