Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Number of bytes used by number data type

Re: Number of bytes used by number data type

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 20 Mar 2003 08:13:44 -0000
Message-Id: <24715.322476@fatcity.com>


See notes on

    http://www.jlcomp.demon.co.uk/faq/num_size.html

There's also a note on the site (though not in the FAQ) about reading internal formats and working out what number it represents.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______April 8th
____UK_______April 22nd

____Denmark May 21-23rd

____USA_(FL)_May 2nd

Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____UK_(Manchester)_May
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

> Guru's
>
> I want to find out the exact space occupied by a number field. E.g I
want to
> find out the space occupied by a field
> NUMBER(7,2). I know oracle has an alogorithm to figure that out .
>
> A quick response would be highly appreciated
Received on Thu Mar 20 2003 - 02:13:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US