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 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 ad ABCDEF.

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