Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle VSIZE Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 57 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?