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;
|