Search a long data type

[cmmrfrds]

I am trying to search the query field on this query.

select
mview_name,
query
from sys.ALL_MVIEWS

The field query is a long data type. I tried to convert to a clob but that gets an error. Is there any way to do this?

Thank you.

 

[ggriffit]

A quick google shows several approaches :

http://www.google.co.uk/search?hl=en&q=oracle+select+long&btnG=Google+Search&meta=

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/