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!

calculate the size of the clob datatype

oracedbaNov 14 2012 — edited Nov 14 2012

i am trying to calculate the avg size of a row, in which i have one column which has clob datatype,

for rest of the datatypes i am using (avg(vsize(col_name,varchar2(10)))), i want a simple function that can calculate the clob datatype.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2012

Added on Nov 14 2012

12 comments

4,349 views