VSIZE

Oracle

VSIZE(item)

• item: The data item which you want to evaluate for size. This could be a varray, nested table, or any other type of data type that you want to determine the size of, including both built-in and user-defined types.

Example

SELECT VSIZE('Oracle') FROM dual;

Output

    VSIZE('Oracle')
--------------------
         6

Explanation

The VSIZE() function in Oracle SQL returns the number of bytes that a value is using. In the example, it returns the byte size of the string ‘Oracle’ which is 6 bytes. Each character in the string is stored using one byte, hence the size is 6.