Skip to Main Content
Forums

Oracle Database Discussions

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!

Managing and Manipulating CLOB

846231Nov 10 2011 — edited Nov 14 2011
Hi All,

Ora11g.

I have a table PRODUCT, with CLOB column DESCR.

How can I display the value of DESCR as text format?And be able to create a script. So that I can use this as a text manual update?
For example:


Above is the sample value of CLOB. How can I "enclose" or concat it so it can be treated as one value?

Thanks a lot.

Edited by: KinsaKaUy? on 11-Nov-2011 02:26
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2011
Added on Nov 10 2011
#general-database-discussions
21 comments
588 views