Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

length vs vsize?use of vsize in practical scenario?

625012May 8 2008 — edited May 23 2008
what 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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 20 2008
Added on May 8 2008
11 comments
1,339 views