Oracle / PLSQL: VSIZE Function

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

Description

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

Syntax

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

VSIZE( expression )

Parameters or Arguments

expression

The string to evaluate.

Returns

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

Example

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

VSIZE(null)
Result: <null>

VSIZE('')
Result: <null>

VSIZE(' ')
Result: 1