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’