We cannot update the view directly if the viw define with more than one ta

What is INSTEAD OF trigger ?

Question Posted / anil siddi

Answer Posted / anil siddi

We cannot update the view directly if the viw define with
more than one table(objects).By using Instead of triggers we
can do that

Is This Answer Correct ?

19 Yes

7 No

Please Help Members By Posting Answers For Below Questions

what is a constraint? : Sql dba

1142

What is before trigger?

997

what are the advantages of sql ? : Sql dba

1052

What is procedure explain with program?

1008

what is subquery? : Sql dba

1122

What is sql*loader?

1171

Is primary key a clustered index?

963

what is the difference between undefined value and null value? : Sql dba

1091

How many types of literals are available in pl sql?

1109

What does the argument [or replace] do?

1071

What are the types of triggers in sql?

1082

What are system versioned tables?

1017

Which data dictionary views have the information on the triggers that are available in the database?

1232

how to enter numeric values as hex numbers? : Sql dba

1057

What is embedded sql with example?

1032