Querying DBA_VIEWS column
Date: Fri, 8 Aug 2008 09:55:06 -0400
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