In 8i and 9i you cannot do that in a long field. (unless you write your own
pl/sql routines) For lobs use dbms_lob. I think in 9i lobs are more
"friendly" and you can use more standard sql functions. Have to read the
docs though.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Paul Taylor" <paul.taylor_at_zen.co.uk> wrote in message
news:vp1j2v417904b4nos5ak56dil63dl4v3kr_at_4ax.com...
> How do I search for something in a LONG or CLOB field? I read that
> Oracle 9 allows these types to be treated like VARCHAR2. But I'm using
> Oracle 8i. I want to do things like LEN and LIKE on a LONG field and
> have never needed to in the past.
Received on Sat Jan 18 2003 - 11:01:42 CST
