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 get rowcount from a Clob

PD81Oct 11 2013 — edited Oct 11 2013

Hi,

Is it possible to get a rowcount from a clob, without writing a loop to iterate/count each row?

I'm working on a CSV extract procedure, which has been passed a Clob parameter and I just need to extract its rowcount.

I was expecting a useful function to exist, but it seems not?

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2013
Added on Oct 11 2013
5 comments
2,659 views