Is there a way to select the code of all triggers?

Question

Oracle

Is there a way to select the code of all triggers in the database, rather than selecting one at a time?
SQL> select dbms_metadata.get_ddl('TRIGGER','trigger_name','owner') from dual;

Answer 1

Lots of options. Let's start with a simple one, if for some reason this is not enough - specify the task.

SELECT DBMS_METADATA.GET_DDL('TRIGGER', trigger_name, owner) FROM dba_triggers;