 | |
NUMBER(0) and NUMBER
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: NUMBER(0) and NUMBER -
08-19-2008
, 11:59 AM
|
On Aug 19, 8:53 am, Norbert Pürringer <thalio... (AT) graffiti (DOT) 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 |
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 --
#12
| |||
| |||
|
|
On Aug 19, 8:53 am, Norbert Pürringer <thalio... (AT) graffiti (DOT) 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 |
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 --
#13
| |||
| |||
|
|
On Aug 19, 8:53 am, Norbert Pürringer <thalio... (AT) graffiti (DOT) 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 |
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 --
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.