What is INSTEAD OF trigger ?

Answer Posted / arvind pandita

In simple words Instead of Trigger is used to update base
tables through view based on base table.
This prevets us to update multiple tables in case of an
Complex view.

Is This Answer Correct ?    19 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention what is the function that is used to transfer a pl/sql table log to a database table?

482


Can one improve the performance of sql*loader? : aql loader

580


What is rank function in sql?

524


What is varchar sql?

611


Does user triggers have entry for trigger with compilation errors?

588






Can you skip header records while loading? : aql loader

537


How global cursor can be declare with dynamic trigger ?

1744


What are the basic sql commands?

544


What is the difference between a database and a relational database?

558


Can I join the same table twice?

522


What is package in pl sql?

573


How do you determine the current isolation level? : Transact sql

575


Is sql the best database?

496


What is the difference between database trigger and stored procedure?

548


Explain sql data types?

620