Oracle export Trigger.
select t.NAME, t.line, 'CREATE OR REPLACE '||TEXT from sys.dba_source t where t.owner = 'USERNAME' and t.TYPE = 'TRIGGER' and line = 1 union select t.NAME, t.line, TEXT from sys.dba_source t where t.owner = 'USERNAME' and t.TYPE = 'TRIGGER' and line > 1 order by 1,2; |
||