How to create a view on a table which does not exists

Answer Posted / amedela chandra sekhar

By using 'force view'
we can create a view without base table

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between % rowtype and type record.

923


What are different types of keys?

737


how many triggers are allowed in mysql table? : Sql dba

761


Explain how exception handling is done in advance pl/sql?

732


Why does sql need a server?

760






what is 'mysqlimport'? : Sql dba

725


What is the use of partition by in sql?

718


What is difference between stored function and application function?

760


Why do we use function in pl sql?

757


Mention what is the use of function "module procedure" in pl/sql?

784


What is the difference between local variables and global variables?

800


what is a cursor? : Sql dba

745


What is a data definition language?

791


Does sql between include endpoints?

748


what is the difference between truncate and delete statement? : Transact sql

778