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

What is Collation Sensitivity ? What are the various type ?

954

How to run sql statements through the web interface?

1047

What is mutating error?

972

Which is faster count (*) or count 1?

1035

What is self-join and what is the requirement of self-join?

1151

Is it possible to create startup or shutdown trigger for on-schema?

1029

Explain the purpose of %type and %rowtype data types?

930

how to shutdown mysql server? : Sql dba

1107

What is the difference between the conventional and direct path loads? : aql loader

1401

what is the difference between delete and truncate statement in sql? : Sql dba

1249

What is scalar function?

1058

Is sql pronounced sequel or sql?

1273

What is compilation error in pl sql?

983

How many commands are in sql?

1074

how can you see all indexes defined for a table? : Sql dba

1000