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