If we update a complex view, is base table will get update ?

Answer Posted / dinesh

Yes We can update base table through complex view
Using "Instead of trigger"

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the difference between inner join and left join?

510


What is clause in sql?

577


How delete all data from table in sql?

568


What is assignment operator in pl sql?

559


How global cursor can be declare with dynamic trigger ?

1745






What are data types in pl sql?

553


What are tables and fields?

584


What are different types of functions in sql?

510


What is pl sql package?

589


Is sql a dbms?

527


Can a table contain multiple primary key’s?

620


How can one get sql*loader to commit only at the end of the load file? : aql loader

560


what is acid property in database? : Sql dba

555


What type of join is sql join?

526


How to know the last executed procedure?

586