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

1 vote143 views1 answer
Calculate age in sql postgresql
SQL
0 vote130 views1 answer
VSCode SQL Server Connection error
SQL
2 votes178 views1 answer
Tcl in sql
SQL
0 vote241 views1 answer
How to get all values in a table mysql in c#
SQL
2 votes151 views1 answer
Guid to string sql
SQL
0 vote128 views1 answer
Sql date between one week
SQL
-1 vote129 views1 answer
Mysql case when multiple conditions
SQL
1 vote155 views1 answer
Sql group by sum with condition
SQL
3 votes142 views1 answer
Sql server check version
SQL
0 vote94 views1 answer
Check id exist or not in sql
SQL