Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to transfer varchar2 to long raw
hi, I have a question:
I hava a table, such as:
Table: T1
Field:
ID varchar(38),
VALUE varchar(4000),
Now I need modify table structure to:
Table: T2
Filed:
ID varchar(38),
VALUE long raw
My question is:
As filed "VALUE" had be changed to long raw,
how to move old record into new table T2 by SQL,
e.g. how to insert a string(such as "Hello World")
into long raw filed by pure sql.
Received on Wed Aug 30 2006 - 20:55:15 CDT
![]() |
![]() |