can we update a view which is created from two tables

Answer Posted / haritha

we can not update a view which is created from two
tables.But we can update a view which is created from one
table.

Is This Answer Correct ?    47 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an escape character in sql?

556


Does asenumerable execute the query?

590


What is the unique index?

515


how to write date and time literals? : Sql dba

520


Explain cursor types?

571






What is percent sign in sql?

708


Why do we use set serveroutput on?

506


Can instead of triggers be used to fire once for each statement on a view?

532


What is nosql db?

529


what is the use of double ampersand (&&) in sql queries?

616


What is row_number () in sql?

530


What is meant by temporal data?

532


Can I join the same table twice?

519


What is interval partition?

537


Explain ddl statements in pl/sql?

568