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 vote145 views1 answer
Set column in all row mysql
SQL
0 vote154 views1 answer
Mysqlimport
SQL
0 vote139 views1 answer
Psql list rules
SQL
0 vote145 views1 answer
How to get inserted id in sql server
SQL
0 vote148 views1 answer
Search db for table name
SQL
3 votes139 views1 answer
Search for column name in psql
SQL
-1 vote142 views2 answers
Get day in sql
SQL
0 vote147 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote143 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote142 views3 answers
How to truncate foreign key constraint table
SQL