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

13 votes171 views6 answers
Restart postgresql
SQL
0 vote233 views1 answer
Mysql get longest string in column
SQL
40 votes166 views6 answers
Update table mysql
SQL
2 votes178 views4 answers
Mysql get all tables row count
SQL
0 vote185 views1 answer
Psql generate id in existing database
SQL
8 votes164 views1 answer
Mac restore mysql database command line
SQL
0 vote153 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote126 views1 answer
Copy table dbeaver
SQL
0 vote180 views1 answer
What does leave do in mysql
SQL
0 vote179 views1 answer
Update and keep original value sql
SQL