Oracle show trigger code

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

2 votes194 views1 answer
Sql column values comma separated
SQL
11 votes372 views4 answers
Round in sql
SQL
0 vote156 views1 answer
Check id exist or not in sql
SQL
0 vote248 views1 answer
Updating database in sql
SQL
2 votes180 views1 answer
Oracle run_duration average
SQL
0 vote194 views1 answer
Laravel eloquent get generated sql
SQL
1 vote200 views1 answer
Mysql show queries running
SQL
1 vote187 views1 answer
Database Queries
SQL
0 vote266 views1 answer
Sql server is not
SQL
10 votes210 views1 answer
How to import database in mysql by cmd
SQL