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!

How to get last x characters from clob using subbstr or some other function

user6287828Jul 12 2011 — edited Jul 12 2011
just like


substr( stringval, pos2, length(stringval)) works as expected but the same for clob does not


dbms_lob.substr( stringval, pos2, dbms_lob.length(stringval) )

the third argument in clob is offset.

so I know the valoe of pos2 and want to concatenate all characters from pos2 to end of clob

Edited by: user6287828 on Jul 12, 2011 2:39 PM

Edited by: user6287828 on Jul 12, 2011 2:40 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2011
Added on Jul 12 2011
2 comments
2,349 views