Oracle get trigger ddl

SELECT DBMS_METADATA.get_ddl('TRIGGER', TRIGGER_NAME, OWNER)
FROM ALL_TRIGGERS		-- or DBA_TRIGGERS, USER_TRIGGERS
WHERE OWNER = 'swhema_name'
  AND TRIGGER_NAME = 'trigger_name';

Similar codes

0 vote215 views1 answer
Mysql server not running
SQL
32 votes246 views6 answers
Rename column mysql
SQL
1 vote190 views1 answer
How to between in sql
SQL
0 vote210 views1 answer
SqlFunction does not exist
SQL
0 vote200 views1 answer
Bigquery declare
SQL
0 vote206 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote192 views4 answers
Mysql count table rows
SQL
3 votes215 views1 answer
Oracle apex message quit website
SQL
6 votes264 views3 answers
Mysql remove user privileges
SQL
0 vote210 views1 answer
Drop unique
SQL