Answer Posted / amol garve
INSTEAD OF triggers describe how to perform insert, update,
and delete operations on a views. INSTEAD OF triggers allow
user to treat view as a table. Using instead of trigger we
insert record in view which actully goes in table.
| Is This Answer Correct ? | 11 Yes | 8 No |
Post New Answer View All Answers
How to rename a table?
How do you update a sql procedure?
How to set up sql*plus output format in oracle?
What is compound trigger?
Does truncate release storage space?
What is the difference between an inner and outer join?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is mutating sql table?
how many triggers are allowed in mysql table? : Sql dba
How do I access sql anywhere database?
What is pls_integer in pl sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is the process of copying data from table a to table b?
what is a constraint? : Sql dba
Why stored procedures are faster than query?