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 vote216 views1 answer
Turn on foreign keys check mysql
SQL
1 vote208 views1 answer
Oracle index partition
SQL
1 vote196 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote183 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote233 views9 answers
Linq to sql converter online
SQL
8 votes187 views1 answer
How to check mysql version in xampp
SQL
0 vote189 views1 answer
Set engine to innodb
SQL
0 vote210 views1 answer
Connect laravel to mysql on mac
SQL
0 vote198 views1 answer
Mysql utc timestamp
SQL
0 vote199 views1 answer
Sql last time database was accessed
SQL