Re: BLOB, LONG, LONG RAW etc.

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 Tue Mar 12 2002 - 09:12:55 CET