Skip to Main Content

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!

max length for CLOB

2929538Apr 13 2015 — edited Apr 14 2015

I am using

SELECT max(DBMS_LOB.GETLENGTH(col)) FROM TABLE_name;

to find the maximum length of the stored in a CLOB column.

and I am getting result as 65464.

is this result in bytes ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2015
Added on Apr 13 2015
6 comments
9,526 views