Skip to Main Content
Forums

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!

update a blob column

User13019948-OracleOct 18 2010 — edited Oct 19 2010
Hi,
I need to update a blob column with a value in another column but not sure of the syntax.

I tried update table table_name set col= (select col from table_name where id =1)

But this returns error "illegal use of long datatype"

Can u please help me with the correct syntax.

Thanks
Deepak
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2010
Added on Oct 18 2010
6 comments
48,577 views