Oracle SQL - Function VSIZE function

Introduction

VSIZE function returns the storage size of a string in Oracle.

The general format for this function is:

VSIZE(string) 

Demo

SQL>
SQL>-- from   ww  w  . j  a v  a  2  s . c  o m
SQL> SELECT VSIZE('this is a test') FROM dual;

VSIZE('THISISATEST')
--------------------
            00014.00

SQL>