Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create trigger before any DML or DDL operations on any schema objects

761559Nov 19 2011 — edited Nov 21 2011
Dears,

I need to create a trigger on schema that fire before any DML or DDL operations on any object (table,view,. . . etc) in the schema.
Can i do this, like "BEFORE insert or update or delete or drop or truncate on SCHEMA" ?

Thanks & Regards,,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2011
Added on Nov 19 2011
14 comments
1,662 views