Re: searches in long data field

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 06 Mar 2000 18:04:06 +0800
Message-ID: <38C38296.30E2@yahoo.com>

Kvaerner wrote:
>
> How do I make a search in a long data field?

C program, or if you know its less than 32k long, then use PL/SQL to fetch it into a varchar2 and use INSTR or LIKE.

In 8.0+, the processing of large datatype is improved considerably with the DBMS_LOB package, and in 8i (I think) there is a TO_LOB function which can translate those nasty LONG's into LOB's

HTH
--

---

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

We are born naked, wet and hungry...then things get worse Received on Mon Mar 06 2000 - 04:04:06 CST