Re: How to transfer varchar2 to long raw

From: tamsun <tamsun_at_gmail.com>
Date: Thu, 31 Aug 2006 15:36:54 +0800
Message-ID: <0o3df21se6ddirdvokv19tsqsgr6lkv4f3@4ax.com>

On Wed, 30 Aug 2006 22:57:20 -0700, DA Morgan <damorgan_at_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. Received on Thu Aug 31 2006 - 02:36:54 CDT