Home -> Usenet -> comp.databases.oracle -> change long row to blob

change long row to blob

From: tracy <tracykim10_at_yahoo.com.hk>
Date: 22 Jun 2004 00:56:33 -0700
Message-ID: <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 - 09:56:33 CEST












Original text of this message