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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,137 views