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

What is INSTEAD OF trigger ?

Question Posted / anil siddi

13 Answers
60818 Views
Hexaware, TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explian rowid, rownum? What are the psoducolumns we have?

946

Explain two easy sql optimizations.

963

what is denormalization. : Sql dba

1045

How bulk collect improves performance?

949

What is the difference between sql and t sql?

966

Can you sum a count in sql?

956

what is an extent ? : Sql dba

1021

What is meaning of <> in sql?

1023

What is #table in sql?

998

Explain what is a field in a database and record in a database?

1016

Define implicit and explicit cursors.

1076

Is sql easier than java?

947

What is fmtonly in sql?

1010

How do I send sql query results to excel?

1007

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1962