Re: BLOB, LONG, LONG RAW etc.

Thanks, Jim and S-marty, I got it.

DL

"S-marty" <monkey_at_ludo.aa> wrote in message news:<a6kdfd$6h2_at_ns4.bih.net.ba>...
> DL wrote in message <604bb90c.0203111005.7828b166_at_posting.google.com>...
> >Hi,
> >
> >I don't have any Oracle reference book, so, I have to make some
> >assumptions here,
> >q1: can multimedia file such as image, video, sound or documents like
> >Word file, PDF file, be stored in either BLOB or LONG or LONG RAW, or
> >... column? I know BLOB is for sure, but don't know the definition of
> >LONG and LONG RAW datatype.
> >q2: and if q1 is clear, that is, these type of files may be stored or
> >pointed to any one of the above-mentioned datatypes, which datatype
> >would be most efficient DML-wise, and logically would most DBA and/or
> >developer use that type for their work?
>
>
> Use BLOB, LONG and LONG ROW are for backward compatibility with oracle 7
>
> >Thanks.
> >
> >DL
Received on Wed Mar 13 2002 - 00:32:11 CET