create a view (simple view) on mutating table write a tigger on view (de

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

Question Posted / mahesh

2 Answers
10521 Views
Oracle, I also Faced
E-Mail Answers

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 language is oracle sql developer?

952

What are all the ddl commands?

1128

Can you have more than one trigger on a table?

951

What is a database trigger?

1026

What is rowtype?

960

What is sql and how does it work?

1100

What are the different types of joins in sql?

1669

What is serial sql?

929

what is schema? : Sql dba

993

Does pl sql work in mysql?

928

What is faster join or subquery?

968

What is memory optimized?

1019

What are the different types of sql commands?

1069

What is sql engine in oracle?

940

What are the types of functions in sql?

972