VSIZE

Purpose

VSIZE() 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

• The return type is NUMBER.

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

Examples

The following example uses the VSIZE() function to query the size in bytes of Hello, World, and OceanBase Database.

obclient> SELECT VSIZE('Hello'), VSIZE('World'), VSIZE('OceanBase Database') FROM DUAL;
+----------------+----------------+----------------------------+
| VSIZE('HELLO') | VSIZE('WORLD') | VSIZE('OCEANBASEDATABASE') |
+----------------+----------------+----------------------------+
|              5 |              5 |                         18 |
+----------------+----------------+----------------------------+
1 row in set