Re: NUMBER(0) and NUMBER
From: Ed Prochak <edprochak_at_gmail.com>
Date: Tue, 19 Aug 2008 07:19:41 -0700 (PDT)
Message-ID: <f39120c7-49f4-4c3e-bccc-9b283288c203@d77g2000hsb.googlegroups.com>
Date: Tue, 19 Aug 2008 07:19:41 -0700 (PDT)
Message-ID: <f39120c7-49f4-4c3e-bccc-9b283288c203@d77g2000hsb.googlegroups.com>
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
Received on Tue Aug 19 2008 - 09:19:41 CDT