-
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
-
Trigger
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