Oracle SQL: 擷取trigger之source code

有以下兩個方式:

  select dbms_metadata.get_ddl('TRIGGER','my_trigger_name', user) from dual

  select text from user_source where name='my_trigger_name' and type='TRIGGER'