Re: How to transfer varchar2 to long raw

On Wed, 30 Aug 2006 22:57:20 -0700, DA Morgan <damorgan@xxxxxxxxx>
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.



.

Relevant Pages

  • Re: AW: mklvcopy 0516-622
    ... before rebuilding and re-importing the database I blasted /dev/zero all over the raw volumes (everything continued to work fine after recreating the ... I have now added 2 new D40 drawers to the system, and built RAID 0 arrays within each drawer. ...
    (AIX-L)
  • Re: How do you STORE your RAW images and organize your JPGs????
    ... When editing I still keep the original jpegs in a subfolder although that's a bit redundant with the raw files. ... This is also how I sort my web galleries. ... I also started to keep a 'Photo Update' blog section which is purely a chronological file of the best shots from each shoot every week or two. ... I had some bad experiences with the ACDSee database becoming corrupt. ...
    (rec.photo.digital.slr-systems)
  • data from Excel into SQL Server 2008 via VBA
    ... Database name is: "Batch Raw Log" ... .AddNew ' create a new record ... .Update ' stores the new record ...
    (microsoft.public.sqlserver.programming)
  • Re: Is dumping from partition and loading to file possible?
    ... same underlying hardware and same OS ... ... The question of 'raw vs file' basically comes down to a question of whether or not your I/O writes are buffered in some sort of cache. ... If the I/O writes are buffered then you stand a chance of losing some data (and possibly corrupting your database) if the system crashes before the buffered writes can be written to disk. ... it all depends on the endianess of the platforms and the version of ASE. ...
    (comp.databases.sybase)
  • Re: ASM - AIX 5.3 - 10.2 ( RAW or RAID) ?
    ... later we can have either file system of choice or make it RAW. ... database instances are sharing these servers already. ... systems for the new database to use ASM. ... Will there be any problem in a situation of server failure when we ...
    (comp.databases.oracle.server)