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 vote305 views1 answer
Check if database exists sql
SQL
0 vote318 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote270 views1 answer
Mariadb list tables
SQL
0 vote333 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote315 views1 answer
Selecting all columns from table sql database
SQL
0 vote318 views1 answer
Sql output select
SQL
0 vote299 views1 answer
This week mysql
SQL
0 vote293 views1 answer
Sql string length postgresql
SQL
0 vote324 views1 answer
How to generate ids in sql
SQL
1 vote297 views1 answer
Apex run 404
SQL