Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to transfer varchar2 to long raw

How to transfer varchar2 to long raw

From: tamsun <tamsun_at_gmail.com>
Date: Thu, 31 Aug 2006 09:55:15 +0800
Message-ID: <f1gcf299gkpta5h69tikqr4h040vl1rb9t@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. Received on Wed Aug 30 2006 - 20:55:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US