如何获取触发器函数内的表名?
类似于Postgres中TG_TABLE_NAME
的东西,比如这个
Oracle 10g或更高版本。
这是user_triggers
视图(如果我正确理解问题的话(。
SQL> create table test (id number, name varchar2(20));
Table created.
SQL> create or replace trigger trg_test
2 before insert on test
3 for each row
4 begin
5 null;
6 end;
7 /
Trigger created.
SQL> select trigger_name, table_name from user_triggers;
TRIGGER_NAME TABLE_NAME
------------------------------ ------------------------------
TRG_TEST TEST --> this is the one I've just created
TRG_AIUD_EMP EMPLOYEES
SQL>