Click here to Skip to main content
15,886,199 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi all,
for the sake of fun i want to create a trigger on schema. so i created a dynamic trigger which fired when a DDl operation performed on the trigger, everything goes fine except for alter statement. the issue is i want to capture that alter statement and disply the type of statement.
can anyone help me to solve this issue.
prefer not to use "like" operator

step 2:
now we will make some more complex situation like as our friend danielsql suggested something like before /after alter alter, before/after alter drop,.....
we have many operation which can done by using alter statement so if we create a constraint using alter statement, the trigger must display constraint type and constraint name.

thanks in advance

regards
Smart003
Posted
Updated 28-Nov-14 4:31am
v2

1 solution

Here you have the DDL activities accepted by Oracle.

BEFORE / AFTER ALTER
BEFORE / AFTER ANALYZE
BEFORE / AFTER ASSOCIATE STATISTICS
BEFORE / AFTER AUDIT
BEFORE / AFTER COMMENT
BEFORE / AFTER CREATE
BEFORE / AFTER DDL
BEFORE / AFTER DISASSOCIATE STATISTICS
BEFORE / AFTER DROP
BEFORE / AFTER GRANT
BEFORE / AFTER NOAUDIT
BEFORE / AFTER RENAME
BEFORE / AFTER REVOKE
BEFORE / AFTER TRUNCATE
AFTER SUSPEND
References: http://psoug.org/reference/ddl_trigger.html[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900