How do I get the size in bytes of a CLOB column in Oracle?
After some thinking i came up with this solution:
SUBSTR returns only the first 4000 characters (max string size)
TO_CHAR converts from CLOB to VARCHAR2
LENGTHB returns the length in Bytes used by the string.