Re: change long row to blob

Sure, go ahead. LONG datatypes are there mostly for backward compatibility. For new applications or existing ones that allow it (and often do), go for LOBs. Most of the restrictions that go with using LONG datatypes are not an issue when using LOB datatypes.

tracykim10_at_yahoo.com.hk (tracy) wrote in message news:<5c91cce9.0406212356.529175ec_at_posting.google.com>...
> I plan to change the datatype from long raw to blob as from tables
> stud_photo and cimpant _image below. But i am not sure if it is a good
> idea. pls advise.
> TQ!
>
>
> SQL> DESC STUD_PHOTO;
> Name Null? Type
> ------------------------------- -------- ----
> STUD_ID NOT NULL VARCHAR2(15)
> STUD_PHOTO LONG RAW
> STUD_UPD_BRANCH VARCHAR2(1)
> STUD_DATETIME DATE
>
> SQL> DESC CONPANY_IMAGE;
> Name Null? Type
> ------------------------------- -------- ----
> IMAGE_ID NOT NULL VARCHAR2(10)
> IMAGE LONG RAW
Received on Tue Jun 22 2004 - 19:06:51 CEST