Does vsize give the currect 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
8:23 UTC
Read the original article
Hit count: 508
vsinstaller
|Oracle
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