Re: Querying DBA_VIEWS column

From: <wfholmes_at_yahoo.com>
Date: Fri, 8 Aug 2008 09:09:37 -0700 (PDT)
Message-ID: <51d5a434-f2b1-4747-ac85-5225c42554d1@d1g2000hsg.googlegroups.com>


On Aug 8, 9:55 am, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> 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.

Go to asktom and search for getlong (it's a pl/sql function). Received on Fri Aug 08 2008 - 11:09:37 CDT

Original text of this message