Trigger text from db

How to see the source of a trigger in the database.
if i give


SQL> select text from user_source where
name='TRIGGER_S_ORG_EXT_ADDR' AND TYPE = 'TRIGGER';

no rows selected

and if i give
SQL> select distinct type from user_source;

TYPE
------------
PROCEDURE

1 row selected.
i am not able to see the source oftrigger. why? How can i see
the source of a trigger in the database.
thanks
joe_kk

Try USER_TRIGGERS.TRIGGER_BODY

- Chris

chris
how to view the whole text of the trigger from the user_triggers
joe_kk

I guess you are trying to view it in SQL*Plus. USER_TRIGGERS.TRIGGER_BODY is of type LONG and in SQL*Plus by default you see only first 80 characters from long datatype. If you want to see more, set the appropriately high number of SQL*Plus's set variable LONG:

SQL> SET LONG 1000000
SQL> SELECT trigger_body FROM user_triggers WHERE.....

Yet another reason not to use that awful tool ;)

- Chris