Re: Search in LONG fields

Alexei Sorokin wrote:
>
> HI all,
> Please, help me find how to search text in LONG filelds??
> Clause WHERE longtxt LIKE '%%' doesn't work
>
> regards
> alexei sorokin

If they are less than 32k, then you can use pl/sql ...

fetch the long into a varchar2(32767)
then use instr to match within the string

You may also get some joy using TO_LOB (8.1.6) and then applying DBMS_LOB functions..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse