how to extract text from LONG field

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Wed, 14 Nov 2001 00:35:54 -0800
Message-ID: <F001.003C427C.20011114001518@fatcity.com>

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 Received on Wed Nov 14 2001 - 02:35:54 CST