VSIZE

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;