Re: change long row to blob

Hi

you can change the datatype of the column by using alter command

here is the example

database version 9.2.0.4

sys_at_ORCL$ create table company_image(image_id varchar2(10),

                                     image    long raw);

sys_at_ORCL$ alter table company_image modify image blob;

Table altered.

sys_at_ORCL$ desc company_image

Name                Null?    Type
-----------------------------------------  
IMAGE_ID                     VARCHAR2(10)
IMAGE                        BLOB

sekhar Received on Thu Jul 01 2004 - 14:22:21 CDT