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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.

Start your free trial