创建触发器仅在创建新表时运行

发布于 2024-10-14 11:39:12 字数 203 浏览 4 评论 0原文

我知道我可以用它来创建DDL创建触发器；

CREATE OR REPLACE TRIGGER 
  create_table_trigger
  AFTER CREATE ON SCHEMA
DECLARE
BEGIN
END;

问题是此触发器将在“创建序列”等 DDL 上运行；我怎样才能只对“创建表”DDL 执行此操作？

I know that I can use this to create DDL create trigger;

CREATE OR REPLACE TRIGGER 
  create_table_trigger
  AFTER CREATE ON SCHEMA
DECLARE
BEGIN
END;

Problem is this trigger would run on DDLs like 'Create sequence'; how can I only execute this for 'Create Table' DDLs?

需要登录才能够评论，你可以免费注册一个本站的账号。

甜尕妞 2024-10-21 11:39:12

CREATE OR REPLACE TRIGGER 
  create_table_trigger
  AFTER CREATE ON SCHEMA
BEGIN
  IF SYS.DICTIONARY_OBJ_TYPE = 'TABLE' THEN
      ....
END;

有关 EVENT 属性的列表，请参阅此页面
http://ist.marshall.edu/ist480adbp/plsql_triggers.html（链接为向下）

和dictionary_obj_name 只是表/序列/proc/等的名称。

CREATE OR REPLACE TRIGGER 
  create_table_trigger
  AFTER CREATE ON SCHEMA
BEGIN
  IF SYS.DICTIONARY_OBJ_TYPE = 'TABLE' THEN
      ....
END;

For a list of EVENT attributes, refer to this page
http://ist.marshall.edu/ist480adbp/plsql_triggers.html (link is down)

And dictionary_obj_name is just the name of the table/sequence/proc/etc.

dictionary_obj_type Returns the type of the dictionary object on which the DDL operation that fired the trigger occurred.
dictionary_obj_name Returns the name of the dictionary object on which the DDL operation that fired the trigger occurred.

~没有更多了~