Re: How to transfer varchar2 to long raw

On Thu, 31 Aug 2006 03:12:25 GMT, Brian Peasland <dba_at_nospam.peasland.net> wrote:

>tamsun wrote:
>> 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.
>
>The LONG RAW datatype is used for BINARY data while the VARCHAR2
>datatype is used for character data. These two are inconsistent with
>each other. You would want to use the LONG datatype instead.
>
>That being said, it makes much more sense if you are creating the table
>anew to use the CLOB datatype as the LONG and LONG RAW datatypes may
>seee their end in the future.
>
>HTH,
>Brian

field F1 is varchar2(4000), I want move the data in F1 into another filed F1 which is long raw.
I wonder how to do by sql? Received on Wed Aug 30 2006 - 23:47:08 CDT