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

Can you load data into multiple tables at once? : aql loader

0 Answers  


What is difference between procedure and trigger?

0 Answers  


How to find the count of letter "L" in HELLO

7 Answers   HP,


What is a variable in sql?

0 Answers  


write a query to delete similar records in same table

13 Answers   TCS,






What are the indexing methods?

0 Answers  


What is materialised View?

2 Answers   IBM,


What is the difference between a subquery and a join?

0 Answers  


How packaged procedures and functions are called from the following?

2 Answers  


Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  


function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,


Categories