VSIZE
VSIZE(expr)

Returns the size, in bytes, of the value's internal representation.

Examples

SQL> SELECT VSIZE(SYSDATE) FROM dual;

VSIZE(SYSDATE)
--------------
             8

SQL> SELECT VSIZE(username) FROM dba_users;

VSIZE(USERNAME)
---------------
              3
              6
              5

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.