Non-standard number data types in Oracle
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
291k46444538
asked Nov 10 at 13:55
Oiale
25329
add a comment |
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
291k46444538
asked Nov 10 at 13:55
Oiale
25329
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 |
1
1
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
291k46444538
asked Nov 10 at 13:55
Oiale
25329
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
291k46444538
asked Nov 10 at 13:55
Oiale
25329
edited Nov 10 at 15:56
a_horse_with_no_name
291k46444538
asked Nov 10 at 13:55
Oiale
25329
edited Nov 10 at 15:56
a_horse_with_no_name
291k46444538
edited Nov 10 at 15:56
a_horse_with_no_name
291k46444538
edited Nov 10 at 15:56
a_horse_with_no_name
291k46444538
291k46444538
asked Nov 10 at 13:55
Oiale
25329
asked Nov 10 at 13:55
Oiale
25329
asked Nov 10 at 13:55
Oiale
25329
25329
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
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
Required, but never shown
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
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
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
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
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