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