Re: How to transfer varchar2 to long raw

tamsun <tamsun@xxxxxxxxx> wrote in
news:f1gcf299gkpta5h69tikqr4h040vl1rb9t@xxxxxxx:


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;
.

Relevant Pages

  • Re: How to transfer varchar2 to long raw
    ... Now I need modify table structure to: ... As filed "VALUE" had be changed to long raw, ... e.g. how to insert a stringinto long raw filed by pure sql. ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.misc)
  • Re: How to transfer varchar2 to long raw
    ... I hava a table, such as: ... Now I need modify table structure to: ... As filed "VALUE" had be changed to long raw, ... into long raw filed by pure sql. ...
    (comp.databases.oracle.misc)
  • How to transfer varchar2 to long raw
    ... I hava a table, such as: ... Now I need modify table structure to: ... As filed "VALUE" had be changed to long raw, ... into long raw filed by pure sql. ...
    (comp.databases.oracle.misc)
  • Re: How to transfer varchar2 to long raw
    ... As filed "VALUE" had be changed to long raw, ... e.g. how to insert a stringinto long raw filed by pure sql. ... The LONG RAW datatype is used for BINARY data while the VARCHAR2 datatype is used for character data. ...
    (comp.databases.oracle.misc)
  • Re: Genuine Fractals
    ... purchase and use Raw files at 16 bit. ... If you're going to edit an image in photoshop or enlarge it, Next time you're using JPG take a look at your histogram while you modify it. ...
    (alt.graphics.photoshop)