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 sql mysql pl sql oracle?
How do I write a sql query in pgadmin 4?
What does rownum mean in sql?
What is acid property in a database?
How do you drop a trigger?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is a trigger in sql?
I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?
When the mutating error will comes? and how it will be resolved?
How does index help in query performance?
please explain database architecture..
Where can I learn sql for free?
Oracle (3259)
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)