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

Thanks Peter,

Good Point.

jasonl
Peter wrote:

> "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 - 12:56:37 CDT