can we update a view which is created from two tables

Answer Posted / arup ratan banerjee

U can update non-updatable views to updatable ones by means
of Instead Of Triggers

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

654


What is java sql driver?

530


What is trigger and how to use it in sql?

528


Is primary key is clustered index?

514


what is the difference between char and varchar data types? : Sql dba

524






what is the difference between sql and t-sql? : Transact sql

584


What are the different types of triggers?

577


Why is theta join required?

649


How do I make sql search faster?

543


What is the difference between distinct and unique in sql?

462


what is the syntax used for partition in tsql? : Transact sql

523


Explain the steps needed to create the scheduled job?

546


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

531


what is a materialized view? : Sql dba

556


What is cartesian join in sql?

546