VSIZE Function in Oracle SQL – PLSQL

The VSIZE Function in Oracle SQL / PLSQL is used to get the number of bytes in the internal representation of an expression

Syntax for the using the VSIZE Function in Oracle SQL / PLSQL is:

SELECT VSIZE(expression)
FROM table_name;
expression is the string to be evaluated.

Examples:

Using VSIZE Function in Oracle SQL / PLSQL SELECT statement:

SELECT VSIZE('Tech Honey')
FROM dual;

Will return ‘10’

SELECT VSIZE('Tech')
FROM dual;

Will return ‘4’

SELECT VSIZE('Tech Honey is a good website')
FROM dual;

Will return ‘28’


Tagged , , , , , , , , , , , . Bookmark the permalink.