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!

how to read clob and iterate through all lines

879687Sep 14 2011 — edited Sep 15 2011
I am attempting to read a table that has clob field. I want to iterate through all rows that are contained in the data of clob. Is it possible to do this?

For example I have some thing like this in my data:
OH, JK, -JKManualTra-Lem_dropping90
TX, KJ, -KJAutoTra-Mel-popping89


The clob could be large itself so I want to be able to extract line by line and I can't figure out how to iterate easily. Anyone can assist please?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2011
Added on Sep 14 2011
16 comments
20,833 views