Oracle VSIZE function.

Preamble

The Oracle/PLSQL VSIZE function returns the length in bytes for the internal representation of the expression.

Syntax of the Oracle/PLSQL VSIZE function

VSIZE( expression_id )

Parameters and function arguments

• expression_id – the expression whose length will be returned by the function.

Note:

The VSIZE function returns a numeric value.

If the expression is NULL, the VSIZE function returns NULL.

The VSIZE function can be used in the following Oracle/PLSQL versions

Let’s consider some examples of the VSIZE function and learn how to use the VSIZE function in Oracle/PLSQL.

SQL> SELECT VSIZE('A bishop and did not suspect') FROM DUAL;

--Result: 28

SQL> SELECT VSIZE('A bishop and did not suspect ') FROM DUAL;

--Result: 29

SQL> SELECT VSIZE(null) FROM DUAL;

--Result: NULL

SQL> SELECT VSIZE('') FROM DUAL;

--Result: NULL

SQL> SELECT VSIZE(' ') FROM DUAL;

--Result: 1

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​