Quick Search:
 
 The Oracle VSIZE Function      [Return To Index] Jump to:  

Term: VSIZE

Definition:
The Oracle VSIZE function returns the size of an expression measured in bytes. The expression can also be a column name. In other words, VSIZE tells you the exact number of bytes allocated by Oracle for data.

Note that since VSIZE returns the internal representation of an expression, it may show a larger than expected size (number of bytes) when Unicode strings are used.

Example Syntax:

VSIZE(expression);



Example Usage:

SELECT VSIZE('how big is this string?') from DUAL;

VSIZE('how big is this string?')
--------------------------------
23
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org