Oracle / PLSQL: VSIZE Function

This article is written about how to use the Oracle/PLSQL VSIZE characteristic with syntax and examples.


The Oracle/PLSQL VSIZE function returns the wide variety of bytes in the inner illustration of an expression.


The syntax for the VSIZE function in Oracle/PLSQL is:

VSIZE( expression )

Parameters or Arguments


The string to evaluate.


The VSIZE feature returns a numeric value. If expression is NULL, then the VSIZE function returns NULL.

Applies To

The VSIZE characteristic can be used in the following versions of Oracle/PLSQL:

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i


Let’s seem to be at some Oracle VSIZE characteristic examples and explore how to use the VSIZE function in Oracle/PLSQL.

For example:

VSIZE('Tech on the net')
Result: 15

VSIZE('Tech on the net ')
Result: 16

Result: <null>

Result: <null>

VSIZE(' ')
Result: 1