Re: change long row to blob
From: cs <sekhar73us_at_yahoo.com>
Date: 1 Jul 2004 12:22:21 -0700
Message-ID: <d1bacc2d.0407011122.38095c0c_at_posting.google.com>
Date: 1 Jul 2004 12:22:21 -0700
Message-ID: <d1bacc2d.0407011122.38095c0c_at_posting.google.com>
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 - 21:22:21 CEST