Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to transfer varchar2 to long raw
On Thu, 31 Aug 2006 02:40:05 GMT, "IANAL_VISTA"
<IANAL_Vista_at_hotmail.com> wrote:
>tamsun <tamsun_at_gmail.com> wrote in
>news:f1gcf299gkpta5h69tikqr4h040vl1rb9t_at_4ax.com:
>
>>
>> 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.
>>
>
>INSERT INTO T2 SELECT * FROM T1;
I try this sql,but error occur:
ORA-01465: invalid hex number
Received on Wed Aug 30 2006 - 23:43:56 CDT