Long raw to blob
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Long raw to blob

  1. #1
    Join Date
    Mar 2002
    Posts
    46
    Hi,

    I need to import a long raw column from a table to another table in a blob field. How can I do that? How use select with long dadatype?

    Thanks
    DONTBSHY

  2. #2
    Join Date
    Jan 2002
    Posts
    152
    You can import the data like this

    Insert into table (blob_value)
    select to_lob(long_value) from table2;

    The long raw data will be converted automatically into blob,and long data will be converted into Clob...

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width