Querying DBA_VIEWS column

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Fri, 8 Aug 2008 09:55:06 -0400
Message-ID: <5hYmk.16083$cW3.4434@nlpi064.nbdc.sbc.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. Received on Fri Aug 08 2008 - 08:55:06 CDT

Original text of this message