Re: Space allocation for Number datatype

From: news.insysnc.net <suresh.bhat_at_mitchell-energy.com>
Date: 1998/03/06
Message-ID: <01bd4949$00c20f00$a504fa80@mndnet>#1/1

Try -- select vsize(number1), vsize(number2) from test_table; -- to find out the internal Oracle representation in bytes of different size numbers. I think it does vary but not a whole lot.

Tansel Ozkan <tansel_at_openix.com> wrote in article <34FD7D10.4B93_at_openix.com>...

Wrote

> Dear Oracle Experts,
>
> If the length of the column
> makes a big difference in space allocation
> Tansel Ozkan
> Macrosoft, Inc.
>
Received on Fri Mar 06 1998 - 00:00:00 CST