Oracle - PL/SQL - VSIZE Function

In Oracle/PLSQL, the vsize function returns the number of bytes in the internal representation of an expression.

The syntax for the vsize function is:

vsize( expression )

expression is the string to evaluate.

Applies To:

· Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

SELECT VSIZE(NULL) FROM dual -- Would return NULL

SELECT VSIZE('Information') FROM dual -- Would return 11