How to see trigger code.

[StickyBit]

Folks,

How can I see the code for my trigger without using procedure builder, is there a table I can view or a command in sqlplus.

Thanks,

StickyBit.

 

[sem]

select trigger_body from [dba|user|all]_triggers

If you use Oracle Procedure Builder you may find them under Tables node.

 

[jee]

Another suggestion - get TOAD (Tool for Oracle Application Developers) from Quest software (

http://www.quest.com).

There is a somewhat limited-function free version available at

http://www.toadsoft.com.

I can't imaging doing PL/SQL programming without TOAD (actually I can because I used to do it).

 

[StickyBit]

Thank you for your input.

StickyBit.