What is the maximum of the number-format in Oracle?
up vote
2
down vote
favorite
I want to know what is the maximum value the number-format?
For example int32 can handle 4.294.967.296 values.
oracle plsql
edited Jun 6 '12 at 6:44
razlebe
6,44663551
asked Aug 12 '10 at 11:45
Husky110
3991521
add a comment |
up vote
2
down vote
favorite
I want to know what is the maximum value the number-format?
For example int32 can handle 4.294.967.296 values.
oracle plsql
edited Jun 6 '12 at 6:44
razlebe
6,44663551
asked Aug 12 '10 at 11:45
Husky110
3991521
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I want to know what is the maximum value the number-format?
For example int32 can handle 4.294.967.296 values.
oracle plsql
edited Jun 6 '12 at 6:44
razlebe
6,44663551
asked Aug 12 '10 at 11:45
Husky110
3991521
I want to know what is the maximum value the number-format?
For example int32 can handle 4.294.967.296 values.
oracle plsql
oracle plsql
edited Jun 6 '12 at 6:44
razlebe
6,44663551
asked Aug 12 '10 at 11:45
Husky110
3991521
edited Jun 6 '12 at 6:44
razlebe
6,44663551
asked Aug 12 '10 at 11:45
Husky110
3991521
edited Jun 6 '12 at 6:44
razlebe
6,44663551
edited Jun 6 '12 at 6:44
razlebe
6,44663551
edited Jun 6 '12 at 6:44
razlebe
6,44663551
6,44663551
asked Aug 12 '10 at 11:45
Husky110
3991521
asked Aug 12 '10 at 11:45
Husky110
3991521
asked Aug 12 '10 at 11:45
Husky110
3991521
3991521
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
5
down vote
accepted
Based on this Oracle's documentation:
The NUMBER datatype stores fixed and floating-point numbers. Numbers
of virtually any magnitude can be stored and are guaranteed portable
among different systems operating Oracle, up to 38 digits of
precision.
The following numbers can be stored in a NUMBER column:
- Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up to 38 significant digits
- Negative numbers from -1 x 10-130 to 9.99..99 x
10125 with up to 38 significant digits
- Zero
- Positive and negative infinity (generated only by importing from an Oracle Version 5 database)
There's also this other documentation which summarizes very well the types and precision for numeric and other data types as well.
edited Nov 9 at 23:53
gmauch
38011122
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
5
down vote
accepted
Based on this Oracle's documentation:
The NUMBER datatype stores fixed and floating-point numbers. Numbers
of virtually any magnitude can be stored and are guaranteed portable
among different systems operating Oracle, up to 38 digits of
precision.
The following numbers can be stored in a NUMBER column:
- Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up to 38 significant digits
- Negative numbers from -1 x 10-130 to 9.99..99 x
10125 with up to 38 significant digits
- Zero
- Positive and negative infinity (generated only by importing from an Oracle Version 5 database)
There's also this other documentation which summarizes very well the types and precision for numeric and other data types as well.
edited Nov 9 at 23:53
gmauch
38011122
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
add a comment |
up vote
5
down vote
accepted
Based on this Oracle's documentation:
The NUMBER datatype stores fixed and floating-point numbers. Numbers
of virtually any magnitude can be stored and are guaranteed portable
among different systems operating Oracle, up to 38 digits of
precision.
The following numbers can be stored in a NUMBER column:
- Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up to 38 significant digits
- Negative numbers from -1 x 10-130 to 9.99..99 x
10125 with up to 38 significant digits
- Zero
- Positive and negative infinity (generated only by importing from an Oracle Version 5 database)
There's also this other documentation which summarizes very well the types and precision for numeric and other data types as well.
edited Nov 9 at 23:53
gmauch
38011122
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
add a comment |
up vote
5
down vote
accepted
up vote
5
down vote
accepted
Based on this Oracle's documentation:
The NUMBER datatype stores fixed and floating-point numbers. Numbers
of virtually any magnitude can be stored and are guaranteed portable
among different systems operating Oracle, up to 38 digits of
precision.
The following numbers can be stored in a NUMBER column:
- Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up to 38 significant digits
- Negative numbers from -1 x 10-130 to 9.99..99 x
10125 with up to 38 significant digits
- Zero
- Positive and negative infinity (generated only by importing from an Oracle Version 5 database)
There's also this other documentation which summarizes very well the types and precision for numeric and other data types as well.
edited Nov 9 at 23:53
gmauch
38011122
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
Based on this Oracle's documentation:
The NUMBER datatype stores fixed and floating-point numbers. Numbers
of virtually any magnitude can be stored and are guaranteed portable
among different systems operating Oracle, up to 38 digits of
precision.
The following numbers can be stored in a NUMBER column:
- Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up to 38 significant digits
- Negative numbers from -1 x 10-130 to 9.99..99 x
10125 with up to 38 significant digits
- Zero
- Positive and negative infinity (generated only by importing from an Oracle Version 5 database)
There's also this other documentation which summarizes very well the types and precision for numeric and other data types as well.
edited Nov 9 at 23:53
gmauch
38011122
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
edited Nov 9 at 23:53
gmauch
38011122
edited Nov 9 at 23:53
gmauch
38011122
edited Nov 9 at 23:53
gmauch
38011122
38011122
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
answered Aug 12 '10 at 11:52
Sachin Shanbhag
42.9k97395
42.9k97395
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f3467258%2fwhat-is-the-maximum-of-the-number-format-in-oracle%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
