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:
1 | SELECT VSIZE( 'Tech Honey' ) |
2 | FROM dual; |
Will return ‘10’
1 | SELECT VSIZE( 'Tech' ) |
2 | FROM dual; |
Will return ‘4’
1 | SELECT VSIZE( 'Tech Honey is a good website' ) |
2 | FROM dual; |
Will return ‘28’