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

Answer Posted / vijayakumar

Using FORCE Command we can create a view without base table.

Is This Answer Correct ?    40 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is view explain with example?

576


What is execute immediate?

608


What is java sql connection?

571


Is mariadb a nosql database?

633


What is rowid in sql?

566






What are two statement types in sql?

611


How to select all records from the table?

676


What is the starting oracle error number?

623


Why do we use triggers?

589


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2055


what are the disadvantages of mysql? : Sql dba

635


Is sql procedural language?

621


How is data stored in sql?

616


Difference between table function and pipelined function?

653


what is sql server agent? : Sql dba

661