Non-standard number data types in Oracle
up vote
1
down vote
favorite
1
Besides the "usual" number data type where precision is greater then scale there are many "non-standard" number data types where scale greater then precision or where scale is negative.
For example
NUMBER(2, 5)means that there are 5 digits in the fractional part, 3 of them is obligatory zeros.
NUMBER(2,-6)Here the scale is -6, which means the value is rounded to millions and the precision is 2, so 2 significant digits can be stored.
Can somebody provide examples of using such data types in practice?
sql oracle sqldatatypes
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
asked Nov 10 at 13:55
Oiale
22617
add a comment |
up vote
1
down vote
favorite
1
Besides the "usual" number data type where precision is greater then scale there are many "non-standard" number data types where scale greater then precision or where scale is negative.
For example
NUMBER(2, 5)means that there are 5 digits in the fractional part, 3 of them is obligatory zeros.
NUMBER(2,-6)Here the scale is -6, which means the value is rounded to millions and the precision is 2, so 2 significant digits can be stored.
Can somebody provide examples of using such data types in practice?
sql oracle sqldatatypes
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
asked Nov 10 at 13:55
Oiale
22617
I don't know of any examples off-hand, but here is a link to an Oracle discussion similar to your question.
– Tim Biegeleisen
Nov 10 at 14:03
@TimBiegeleisen Thx for your link.
– Oiale
Nov 10 at 14:11
2
I don't understand your question. Are you asking to see concrete uses of such specifications in Oracle, or are you asking for examples of use cases, where one would need to use them (instead of, say, the genericNUMBERdata type)? As in, "why would one ever need to use them"? Note that the latter is not a technical question; strictly speaking it would be out of scope for SO.
– mathguy
Nov 10 at 15:28
@mathguy Thanks for your resonse. I asked about general use of such number data types (second option in your comment). If this question doesn't fit to SO can you give me a piece of advice where I can ask this question?
– Oiale
Nov 10 at 15:35
add a comment |
up vote
1
down vote
favorite
1
up vote
1
down vote
favorite
1
1
Besides the "usual" number data type where precision is greater then scale there are many "non-standard" number data types where scale greater then precision or where scale is negative.
For example
NUMBER(2, 5)means that there are 5 digits in the fractional part, 3 of them is obligatory zeros.
NUMBER(2,-6)Here the scale is -6, which means the value is rounded to millions and the precision is 2, so 2 significant digits can be stored.
Can somebody provide examples of using such data types in practice?
sql oracle sqldatatypes
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
asked Nov 10 at 13:55
Oiale
22617
Besides the "usual" number data type where precision is greater then scale there are many "non-standard" number data types where scale greater then precision or where scale is negative.
For example
NUMBER(2, 5)means that there are 5 digits in the fractional part, 3 of them is obligatory zeros.
NUMBER(2,-6)Here the scale is -6, which means the value is rounded to millions and the precision is 2, so 2 significant digits can be stored.
Can somebody provide examples of using such data types in practice?
sql oracle sqldatatypes
sql oracle sqldatatypes
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
asked Nov 10 at 13:55
Oiale
22617
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
asked Nov 10 at 13:55
Oiale
22617
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
edited Nov 10 at 15:56
a_horse_with_no_name
285k45427525
285k45427525
asked Nov 10 at 13:55
Oiale
22617
asked Nov 10 at 13:55
Oiale
22617
asked Nov 10 at 13:55
Oiale
22617
22617
I don't know of any examples off-hand, but here is a link to an Oracle discussion similar to your question.
– Tim Biegeleisen
Nov 10 at 14:03
@TimBiegeleisen Thx for your link.
– Oiale
Nov 10 at 14:11
2
I don't understand your question. Are you asking to see concrete uses of such specifications in Oracle, or are you asking for examples of use cases, where one would need to use them (instead of, say, the genericNUMBERdata type)? As in, "why would one ever need to use them"? Note that the latter is not a technical question; strictly speaking it would be out of scope for SO.
– mathguy
Nov 10 at 15:28
@mathguy Thanks for your resonse. I asked about general use of such number data types (second option in your comment). If this question doesn't fit to SO can you give me a piece of advice where I can ask this question?
– Oiale
Nov 10 at 15:35
add a comment |
I don't know of any examples off-hand, but here is a link to an Oracle discussion similar to your question.
– Tim Biegeleisen
Nov 10 at 14:03
@TimBiegeleisen Thx for your link.
– Oiale
Nov 10 at 14:11
2
I don't understand your question. Are you asking to see concrete uses of such specifications in Oracle, or are you asking for examples of use cases, where one would need to use them (instead of, say, the genericNUMBERdata type)? As in, "why would one ever need to use them"? Note that the latter is not a technical question; strictly speaking it would be out of scope for SO.
– mathguy
Nov 10 at 15:28
@mathguy Thanks for your resonse. I asked about general use of such number data types (second option in your comment). If this question doesn't fit to SO can you give me a piece of advice where I can ask this question?
– Oiale
Nov 10 at 15:35
I don't know of any examples off-hand, but here is a link to an Oracle discussion similar to your question.
– Tim Biegeleisen
Nov 10 at 14:03
I don't know of any examples off-hand, but here is a link to an Oracle discussion similar to your question.
– Tim Biegeleisen
Nov 10 at 14:03
@TimBiegeleisen Thx for your link.
– Oiale
Nov 10 at 14:11
@TimBiegeleisen Thx for your link.
– Oiale
Nov 10 at 14:11
2
2
I don't understand your question. Are you asking to see concrete uses of such specifications in Oracle, or are you asking for examples of use cases, where one would need to use them (instead of, say, the generic
NUMBER data type)? As in, "why would one ever need to use them"? Note that the latter is not a technical question; strictly speaking it would be out of scope for SO.– mathguy
Nov 10 at 15:28
I don't understand your question. Are you asking to see concrete uses of such specifications in Oracle, or are you asking for examples of use cases, where one would need to use them (instead of, say, the generic
NUMBER data type)? As in, "why would one ever need to use them"? Note that the latter is not a technical question; strictly speaking it would be out of scope for SO.– mathguy
Nov 10 at 15:28
@mathguy Thanks for your resonse. I asked about general use of such number data types (second option in your comment). If this question doesn't fit to SO can you give me a piece of advice where I can ask this question?
– Oiale
Nov 10 at 15:35
@mathguy Thanks for your resonse. I asked about general use of such number data types (second option in your comment). If this question doesn't fit to SO can you give me a piece of advice where I can ask this question?
– Oiale
Nov 10 at 15:35
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
draft saved
draft discarded
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
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53239670%2fnon-standard-number-data-types-in-oracle%23new-answer', 'question_page');
}
);
Post as a guest
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
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
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
I don't know of any examples off-hand, but here is a link to an Oracle discussion similar to your question.
– Tim Biegeleisen
Nov 10 at 14:03
@TimBiegeleisen Thx for your link.
– Oiale
Nov 10 at 14:11
2
I don't understand your question. Are you asking to see concrete uses of such specifications in Oracle, or are you asking for examples of use cases, where one would need to use them (instead of, say, the generic
NUMBERdata type)? As in, "why would one ever need to use them"? Note that the latter is not a technical question; strictly speaking it would be out of scope for SO.– mathguy
Nov 10 at 15:28
@mathguy Thanks for your resonse. I asked about general use of such number data types (second option in your comment). If this question doesn't fit to SO can you give me a piece of advice where I can ask this question?
– Oiale
Nov 10 at 15:35