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 |
How is a PL/SQL code compiled?
What are sql functions? Describe in brief different types of sql functions?
what is self join and why is it required? : Sql dba
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
How to Execute a Package in PL/SQL.?
Explain the advantages and disadvantages of stored procedure?
What is sql keyword?
What is the purpose of cursors in pl/sql?
Why do we use sql constraints?
What is a sql driver?
Explain isolation levels. : Transact sql
What is the difference between in and between in sql?
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)