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