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 |
What is difference between function and trigger?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
how to use 'mysql' to run sql statements? : Sql dba
What are the types of functions in sql?
Can you selectively load only those records that you need? : aql loader
How to run sql commands in sql*plus?
How is data stored in sql?
What is the use of %rowtype?
Which operator is used in query for pattern matching?
what is the use of double ampersand (&&) in sql queries?
Why is %isopen always false for an implicit cursor?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)