Re: NUMBER(0) and NUMBER

On Aug 19, 10:19 am, Ed Prochak <edproc..._at_gmail.com> wrote:
> On Aug 19, 8:53 am, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
>
> > Hello,
>
> > what does the datatype NUMBER(0) mean? Is it the same as NUMBER, which
> > can be seen in turn as FLOAT?
>
> > Thank you,
> > Norbert
>
> Have you considered TRYING it??
>
> create table ejp
> (id number(0))
> Error at line 1
> ORA-01727: numeric precision specifier is out of range (1 to 38)
>
> Script Terminated on line 1.
>
> HTH,
>   Ed

Norbert, The Oracle rdbms number datatype is really not the same as float. It can best be described as a form of scientific notation. Oracle uses internal library routines to handle the data.

Prior to version 10g and the BINARY_FLOAT and BINARY_DOUBLE data types all numeric values in Oracle were stored as type number. If FLOAT is used as a table column data type Oracle stores the data as a number data type and applys restrictions for the maximum and minimum allowed values.

HTH -- Mark D Powell -- Received on Tue Aug 19 2008 - 11:59:41 CDT