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 are the types of subquery? : Sql dba

1155

What will you get by the cursor attribute sql%notfound?

1128

Which command is used to delete a trigger?

1403

What are the query optimization techniques?

995

how to enter characters as hex numbers? : Sql dba

1102

How does one use sql*loader to load images, sound clips and documents? : aql loader

1233

What is native sql query?

1074

explain primary keys and auto increment fields in mysql : sql dba

1015

What does cursor do in sql?

1067

What are the types of functions in sql?

1062

What is full form of rtm?

1051

Is sql easier than java?

1068

What is type and rowtype in pl sql?

1055

What are aggregate and scalar functions?

1083

Which is faster joins or subqueries?

1034