Re: copy a table with a long raw column

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 30 Nov 1999 18:17:31 +0800
Message-ID: <3843A43B.2015@yahoo.com>

sofresud wrote:
>
> 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

Check the COPY command in SQL Plus - it will handle "nasty" columns like this...
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Nov 30 1999 - 04:17:31 CST