Oracle SQL - Function VSIZE function

  1. HOME
  2. Oracle SQL
  3. Function
  4. 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   www .  j a  va2  s .c o  m
SQL> SELECT VSIZE('this is a test') FROM dual;

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

SQL>