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!

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.

Get length of clob data

User_8NS7EMay 4 2022 — edited May 4 2022

All,

I am column of type Clob in oracle DB.
some of them are having value but some are having null.
how to count rows which are having value.
i was trying to use
dbms_lob.getlength

but it is showing error message "illegal use of long data type"

Comments
Post Details
Added on May 4 2022
8 comments
4,147 views