On Wed, 30 Aug 2006 22:57:20 -0700, DA Morgan <damorgan@psoug.org>
wrote:

>tamsun wrote:
>
>> 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?
>
>Why LONG RAW?
>What is the business case?
>In which version of Oracle?

The real field name is YFBZYJ in table T1 and T2.
I use Oracle 9i.

Some one design the database, the field YFBZYJ is
used for client to fill opinion which maybe
100 characters, or maybe 5,000 characters long.
So the designer change the origin field type
from varchar2(4000) to Long Raw.

Yes, Blob or Clob will be better.But web developers use
a interface to operate database. This interface can only
deal with long raw.

I am responsible to dealing with data. Now I should
move data to new table with the long raw field.