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;
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.
how to view the whole text of the trigger from the user_triggers
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.....
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Yet another reason not to use that awful tool
Click Here to Expand Forum to Full Width