length vs vsize?use of vsize in practical scenario?
625012May 8 2008 — edited May 23 2008what is the actual difference between length and vsize function.?
on what condition vsize function should be used ?
how does vsize calculates for date and number datatype?
i came across these things
can you please tell me why this type of result is coming.
SQL> select vsize(1234567890123) from dual;
VSIZE(1234567890123)
--------------------
8
SQL> select vsize(12345678901234) from dual;
VSIZE(12345678901234)
---------------------
8
SQL> select vsize(sysdate) from dual;
VSIZE(SYSDATE)
--------------
7
why the size of sysdate is 7.....and the size of these
two different number with different length is same.
thanks