Re: LONG vs. CLOB for XML and other CHAR file types

From: Peter <P.Slingerland_at_IMN.nl>
Date: Fri, 8 Sep 2000 08:29:36 +0200
Message-ID: <8pa184$54$1@nereid.worldonline.nl>

"Jason Ladew" <devdewboy_at_hotmail.com> wrote in message news:39B7E408.49040368_at_hotmail.com...
> Hello,
>
> Oracle recommends to store XML file type in CLOBs. Why would I use CLOBs
> vs. LONGS. I see no difference other than a LONG can hold up to 2 gigs
> and CLOBs up to 4gigs.
>
> Any data on this would be appreciated.
>
> please reply to DEVDEWBOY_at_HOTMAIL.COM
>
> thanks
>

Oracle supplies a package DBMS_LOB to read write and search BLOB, CLOB and BFILE. It provides you with SUBSTR and INSTR functionality for example. LONG columns are not supported by this package.

Peter. Received on Fri Sep 08 2000 - 01:29:36 CDT