Yes , we can update a view which is based on more than one table. And dat

can we update a view which is created from two tables

Question Posted / guest

Answer Posted / guest

Yes , we can update a view which is based on more than one
table. And data will get updated in base tables also.

Is This Answer Correct ?

21 Yes

28 No

Please Help Members By Posting Answers For Below Questions

Does sql between include endpoints?

989

What is union, minus and interact commands?

1272

What is a dynamic query?

1008

Can we connect to postgresql using sql developer?

982

What is cursor explain with example?

965

What are the datatypes available in pl/sql ?

1085

What is a table partition?

1106

Can a view be mutating? If yes, then how?

1005

What is sql data?

974

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1094

what are sequences

1722

What are tuples in sql?

1115

What does pl sql stand for?

1097

Which one is faster ienumerable or iqueryable?

917

Write the alter statement to enable all the triggers on the t.students table.

1111