clob size oracle code example

Example: get clob size oracle

SELECT (DBMS_LOB.getlength(your_column_name))/1024/1024 AS SizeMB FROM your_table