Hi!
Is there a way that I can extract the source code of a trigger from dba_triggers? The problem is that the information is stored in a LONG colum.
SQLWKS> desc dba_triggers
Column Name Null? Type
------------------------------ -------- ----
OWNER VARCHAR2(30)
TRIGGER_NAME VARCHAR2(30)
TRIGGER_TYPE VARCHAR2(16)
TRIGGERING_EVENT VARCHAR2(216)
TABLE_OWNER VARCHAR2(30)
BASE_OBJECT_TYPE VARCHAR2(16)
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
REFERENCING_NAMES VARCHAR2(128)
WHEN_CLAUSE VARCHAR2(4000)
STATUS VARCHAR2(8)
DESCRIPTION VARCHAR2(4000)
ACTION_TYPE VARCHAR2(11)
TRIGGER_BODY LONG
select table_owner, table_name from dba_triggers
where trigger_body like '%T_JOURNAL%';
does not work, because the LONG field can't be searched with LIKE. to_char conversion doesn't work either.
Any ideas?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
