can we update a view which is created from two tables

Question Posted / haritha

Answers were Sorted based on User's Feedback

can we update a view which is created from two tables..

Answer / 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

More SQL PLSQL Interview Questions

Explain character-manipulation functions?

what are wild cards used in database for pattern matching ? : Sql dba

pl/sql testing means what ...... explain process how to find pl/sql bugs

what is the difference between a having clause and a where clause? : Sql dba

Can we call dml statement in function?

what does it mean to have quoted_identifier on? : Sql dba

Can we use view in stored procedure?

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

How to display Row Number with Records in Oracle SQL Plus?

what is blob? : Sql dba

What is embedded sql with example?

Explain the usage of WHERE CURRENT OF clause in cursors ?

For more SQL PLSQL Interview Questions Click Here