BLOB, LONG, LONG RAW etc.

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?

Thanks.

DL Received on Mon Mar 11 2002 - 19:05:25 CET