How to get SQL statement for a trigger in ORACLE v10.2 database

Would like to get the sql statements for a trigger in Oracle database. For example,
--trigger tr1
CREATE OR REPLACE TRIGGER  tr1
......
end;
What sql statement should I issue to see the tr1's sql statements? i.e.,
--trigger tr1
CREATE OR REPLACE TRIGGER  tr1
......
end;



jl66Asked:
Who is Participating?
 
sdstuberCommented:
 SELECT *
    FROM dba_source
   WHERE TYPE = 'TRIGGER' AND name = 'TR1'
ORDER BY line
0
 
awking00Commented:
To see the sql only, just select text instead of * in sdstuber's query. You may also want to add "WHERE owner = <'SCHEMA_NAME'>"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.