VSIZE function returns the number of bytes.
Example Syntax:
VSIZE(expression);
If expression is null then this function returns null. This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.
Example:
select vsize('Total number of bytes in the string') from dual;
VSIZE('TOTALNUMBEROFBYTESINTHESTRING')
--------------------------------------------------------
35
SELECT last_name, VSIZE (last_name) "BYTES"
FROM employees
WHERE department_id = 30;
LAST_NAME BYTES
--------------- ----------
Munna 5
select C.COLUMN_NAME,C.DATA_LENGTH from all_tab_columns c
where C.TABLE_NAME='BONUS'
and C.OWNER='SCOTT'
order by C.COLUMN_NAME;