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;
 
COLUMN_NAME
DATA_LENGTH
COMM
22
ENAME
10
JOB
9
SAL
22


Comments