OraFAQ Forum: SQL & PL/SQL » vsize function

Home » SQL & PL/SQL » SQL & PL/SQL » vsize function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

vsize function [message #331]

Tue, 05 February 2002 18:34

hemant shah
Messages: 5
Registered: February 2002

Junior Member

vsize(384838) answer is 4. Plase explain.

Report message to a moderator

Re: vsize function [message #336 is a reply to message #331]

Wed, 06 February 2002 04:11

Mike
Messages: 417
Registered: September 1998

Senior Member

It is the number of bytes used to store your number. It is stored under the format 3.84838 * 10^5. One byte is used for the exponent and 3 for the number.

With larger numbers it can happen, like VSIZE(10000000)=2, that the result is smaller because it will only store the exponent which always uses 1 byte and the number, 1 in this case, which also uses only 1 byte.

HTH
Mike

Report message to a moderator

Re: vsize function [message #348 is a reply to message #331]

Wed, 06 February 2002 07:57

hemant shah
Messages: 5
Registered: February 2002

Junior Member

Thanks Mike.
With larger numbers it can happen, like VSIZE(10000000)=2, that the result is smaller because it will only store the exponent which always uses 1 byte and the number, 1 in this case, which also uses only 1 byte

In other words, 10^7=10,000,000 exponent 1 byte
How did you get the second byte?

Report message to a moderator