SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get a trigger's body

447756Sep 7 2006 — edited Sep 7 2006

Hi,

I have to get a trigger's body from SqlPlus but I don't know how.

I tried the following but it returns the first 4 or 5 rows from the body or something like this:

select trigger_body from user_triggers where trigger_name = 'XXX'

Can someone please let me know how to get the missing body (all of it)?

Thanks in advance,
teo

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2006

Added on Sep 7 2006

6 comments

4,294 views