VSIZE

Purpose

This function returns the size in bytes of the expr parameter.

Syntax

VSIZE (expr)

Parameters

expr can be a value or expression of a numeric data type (NUMBER, FLOAT, BINARY_FLOAT, or BINARY_DOUBLE) or a character data type (CHAR, VARCHAR2, NCHAR, or NVARCHAR2).

Return data type

• A NUMBER value is returned.

• If NULL is specified for expr, the function returns NULL.

Examples

Use the VSIZE function to query the size in bytes of 123456, and ABCDEF.

obclient> SELECT VSIZE(123456),VSIZE('ABCDEF') FROM DUAL;
+---------------+-----------------+
 VSIZE(123456)  VSIZE('ABCDEF')        
+---------------+-----------------+
             8                6    
+---------------+-----------------+
1 row in set