Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nlpi057.nbdc.sbc.com!prodigy.net!flpi088.ffdc.sbc.com!prodigy.com!flpi107.ffdc.sbc.com!nlpi064.nbdc.sbc.com.POSTED!89d291a9!not-for-mail
From: "Dereck L. Dietz" <dietzdl@ameritech.net>
Newsgroups: comp.databases.oracle.server
Subject: Querying DBA_VIEWS column
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
Message-ID: <5hYmk.16083$cW3.4434@nlpi064.nbdc.sbc.com>
NNTP-Posting-Host: 68.248.15.35
X-Complaints-To: abuse@prodigy.net
X-Trace: nlpi064.nbdc.sbc.com 1218203841 ST000 68.248.15.35 (Fri, 08 Aug 2008 09:57:21 EDT)
NNTP-Posting-Date: Fri, 08 Aug 2008 09:57:21 EDT
Organization: at&t http://my.att.net/
X-UserInfo1: S[O[RZSEARP[BPH]OJHNO_PAAB]@PAPDLXUNNHLIWIWTEPIB_NVUAH_[BL[\IRKIANGGJBFNJF_DOLSCENSY^U@FRFUEXR@KFXYDBPWBCDQJA@X_DCBHXR[C@\EOKCJLED_SZ@RMWYXYWE_P@\\GOIW^@SYFFSWHFIXMADO@^[ADPRPETLBJ]RDGENSKQQZN
Date: Fri, 8 Aug 2008 09:55:06 -0400
Xref: usenetserver.com comp.databases.oracle.server:447056
X-Received-Date: Fri, 08 Aug 2008 09:57:02 EDT (text.usenetserver.com)

Oracle 10.2.0.1.0
Windows 2003 Server

My manager is trying to run this query against the DBA_VIEWS column:

SELECT * FROM DBA_VIEWS WHERE OWNER = 'HBL' AND TEXT LIKE '%PRV_SGND_DI%'

but receives ORA-00932 because the TEXT column in the DBA_VIEWS is a LONG 
column.

Does anybody know a way around so that the column can be searched?

Thanks.