Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> 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@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 - 02:56:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US