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

0 vote334 views1 answer
Mysql to get column name in database
SQL
0 vote355 views1 answer
Sql missing values
SQL
0 vote316 views2 answers
Sqlite
SQL
2 votes345 views1 answer
Datetrunc
SQL
0 vote326 views1 answer
Postgres call view
SQL
0 vote351 views1 answer
View t-sql mail configuration
SQL
0 vote342 views1 answer
Mysql cli output to a file
SQL
0 vote367 views1 answer
Acutal month year
SQL
-1 vote323 views1 answer
Count occurrences sql
SQL
1 vote380 views1 answer
UseSqlServer no definition
SQL