• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

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;



0
jl66
Asked:
jl66
2 Solutions
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now