VSIZE function returns the number of bytes.

Example Syntax:

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;

COLUMN_NAME

DATA_LENGTH

COMM

22

ENAME

10

JOB

9

SAL

22