Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inserting value into long raw column

user549774Jul 16 2018 — edited Jul 30 2018

i have two tables.i am trying to insert long raw values from one table into another table.

This long raw column contains the PDF Contents.Contents are stored in bytes.

These tables are old tables.So i am not able to change the data type into BLOB.

So please help.

Table Structure

TEST1

ID number

F_PDF long raw

TEST2

ID number

F_PDF Long Raw

i tried below insert command

insert into test2(id,f_pdf) select id,f_pdf from test1

This post has been answered by Solomon Yakobson on Jul 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2018
Added on Jul 16 2018
8 comments
7,471 views