我们如何为alter语句生成ddl触发器 [英] how can we generate a ddl trigger for an alter statement

问题描述

大家好，

为了好玩，我想在架构上创建一个触发器。所以我创建了一个动态触发器，当触发器执行DDl操作时触发，除了alter语句外一切正常。问题是我想捕获alter语句并显示语句类型。

任何人都可以帮我解决这个问题。

不想使用喜欢运算符



第2步：

现在我们会做一些更复杂的情况，比如我们的朋友danielsql建议像alter alter之前/之后，在alter drop之前/之后，.....

我们有很多操作可以通过使用alter语句完成，因此如果我们使用alter语句创建约束，则触发器必须显示约束类型和约束名称。



提前感谢



问候

Smart003

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

推荐答案

您可以在此接受Oracle接受的DDL活动。



之前/之后

分析之前/之后

之前/之后的协会统计数据

之前/之后审核

之前/之后评论

之前/之后创建

之前/之后DDL

之前/之后的消息统计

之前/之后

之前/之后

之前/之后未付款

在重建之前/之后

之前/之后

之前/之后的b
$ b暂停之后

参考文献： http://psoug.org/reference/ddl_trigger.html [ ^ ]

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[^]

这篇关于我们如何为alter语句生成ddl触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！