Re: NUMBER(0) and NUMBER

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

SQL> create table numtest(
  2 col1 number(0),
  3 col2 number
  4 );
col1 number(0),

             *
ERROR at line 2:
ORA-01727: numeric precision specifier is out of range (1 to 38)

SQL> It means, apparently, that someone doesn't understand the NUMBER datatype in Oracle. And NUMBER, absent a precision specifier, is equivalent to using NUMBER(38).

David Fitzjarrell Received on Tue Aug 19 2008 - 09:18:17 CDT