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: 432
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