How to create a view on a table which does not exists
Answers were Sorted based on User's Feedback
Answer / vijayakumar
Using FORCE Command we can create a view without base table.
Is This Answer Correct ? | 40 Yes | 1 No |
Answer / amedela chandra sekhar
By using 'force view'
we can create a view without base table
Is This Answer Correct ? | 14 Yes | 1 No |
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 |
Answer / senthil
sorry, i am not understand..... emp table is not exit meaning?
Is This Answer Correct ? | 1 Yes | 1 No |
Can you load data into multiple tables at once? : aql loader
What is difference between procedure and trigger?
How to find the count of letter "L" in HELLO
What is a variable in sql?
write a query to delete similar records in same table
What are the indexing methods?
What is materialised View?
What is the difference between a subquery and a join?
How packaged procedures and functions are called from the following?
Are there any features that are decommissioned in 11g that are not present in 11g?
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..