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;
    

Kopieren