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>--   w ww . j a v a2 s .c o m
SQL> SELECT VSIZE('this is a test') FROM dual;

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

SQL>