Character String Functions Oracle PLSQL Tutorial

The general format for this function is: VSIZE(string).

SQL> SELECT VSIZE('Returns the storage size of a string') FROM dual;
VSIZE('RETURNSTHESTORAGESIZEOFASTRING')
---------------------------------------
                                     36
SQL>