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 are tables and fields in the database?
What is the example of procedure?
What is the diffrence between IN and EXISTS.which one is faster.
can we update a view which is created from two tables
how do you count the duplicate records in a table
What is pl sql script?
display your age in months?
in procedure how to return a value
Do you know the basic structure of PL/SQL?
What is the difference between row level and statement level trigger?
how to fetch common records from two tables? : Sql dba
what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?
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)