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

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 vsinstaller

Related posts about Oracle