how instead of triger is helpful for mutating tables errors
handlling ?

Answer Posted / mahesh

create a view (simple view) on mutating table

write a tigger on view (define similar to table)


Know try to do dml operations on table

it will not show the mutating error

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scalar function in sql?

532


Where not exists in sql?

503


How to create an array in pl/sql?

584


What is full form of rtm?

535


What is primary key and unique key?

547






Is drop table faster than truncate?

551


Describe different types of general function used in sql?

532


How can you select unique records from a table?

521


Is sql scripting language?

528


What is t sql used for?

551


What is $$ in sql?

555


Can we insert delete data in view?

544


What is sql architecture?

561


how can we destroy the session, how can we unset the variable of a session? : Sql dba

554


What is sql*plus?

573