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

Home -> Community -> Usenet -> c.d.o.server -> copy a table with a long raw column

copy a table with a long raw column

From: sofresud <sofresud_at_wanadoo.fr>
Date: Tue, 30 Nov 1999 14:36:34 +0100
Message-ID: <820j4t$qkh$1@wanadoo.fr>


I would like to copy some rows of a table that contains a LONG RAW column to another table.
this is on Oracle 7.3.4
i tried :
insert into DESTINATION Select Col1, Col2, Col3 from SOURCE where Col1=MYFILTER;

but as i thought it doesn't work ! cause the Col2 is a raw format. do u have a idea how can i do a such thing, SQL or PL/SQL procedure ?

thank you Received on Tue Nov 30 1999 - 07:36:34 CST

Original text of this message

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