Vsize: returns the storage size of a string in Oracle : VSIZE « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. VSIZE

Vsize: returns the storage size of a string in Oracle

 

SQL>
SQL>
SQL> -- Vsize: returns the storage size of a string in Oracle.
SQL>
SQL> -- VSIZE(string)
SQL>
SQL> SELECT VSIZE('Returns the storage size of a string') FROM dual;

VSIZE('RETURNSTHESTORAGESIZEOFASTRING')
---------------------------------------
                                     36

SQL>
SQL>
SQL>
SQL>








Related examples in the same category

1.Use vsize for varchar2 value and nvarchar value
2.Check the data size for number type column