Oracle/PLSQL: 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:

vsize('Tech on the net')	would return 15
vsize('Tech on the net ')	would return 16
vsize(null)	would return <null>
vsize('')	would return <null>
vsize(' ')	would return 1