Does vsize give the correct result for number?

Posted by sathish reddy on Stack Overflow See other posts from Stack Overflow or by sathish reddy
Published on 2010-03-29T08:16:19Z Indexed on 2010/03/29 13:53 UTC
Read the original article Hit count: 436

Filed under:
|

When I create a table as

Create Table e_det(eno Number, ename Varchar2(20), sal Number);

I inserted

eno as 111
ename as jone
sal as 2000

vsize(ename) returns 4 because name is 4 characters.

vsize(sal); returns 2.

Can you explain this?

© Stack Overflow or respective owner

Related posts about vsize

Related posts about Oracle