vsize的用法

vsize(some-expression)

vsize is a function that returns the size of some-expression measured in bytes.
some-expression can also be a column name.
Size of a number:
select vsize(3.141) from dual;

VSIZE(3.141)
------------
           4

Size of a string:
select vsize('what is my size') from dual;

VSIZE('WHATISMYSIZE')
---------------------
                   15

Size of columns:
create table vsize_test (
  a number,
  b varchar2(10),
  c date
);

insert into vsize_test values (      1,'foo'   , sysdate      );
insert into vsize_test values (   1001,'aladin', sysdate-10000);
insert into vsize_test values (209.209, null   , sysdate+10000);

select vsize(a), vsize(b), vsize(c) from vsize_test;

  VSIZE(A)   VSIZE(B)   VSIZE(C)
---------- ---------- ----------
         2          3          7
         3          6          7
         5                     7