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 vote111 views1 answer
Md5 encryption for existing records
SQL
13 votes127 views2 answers
Sql join 3 tables
SQL
0 vote116 views1 answer
MySQL - How to find word with the most similar beginning
SQL
6 votes98 views4 answers
Mysql update set
SQL
15 votes109 views4 answers
How to get all tables in sql
SQL
1 vote94 views1 answer
Index a database column sql
SQL
1 vote102 views1 answer
Importance of comment in mysql
SQL
0 vote115 views1 answer
Migration graphql
SQL
1 vote151 views1 answer
Sql server delete top 1000
SQL
0 vote110 views1 answer
Get role postgres
SQL