Re: Querying DBA_VIEWS column
Date: Fri, 8 Aug 2008 09:09:37 -0700 (PDT)
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
> Does anybody know a way around so that the column can be searched?
Go to asktom and search for getlong (it's a pl/sql function). Received on Fri Aug 08 2008 - 11:09:37 CDT