Numbers can be stored in Oracle according to different formats. On one hand, we have the American way, whereby numbers are stored with a dot (.) as decimal indicator. On the other hand, we have a comma (,) as decimal indicator. Let me provide my own Oracle instance.<\/p>\n\n\n\n
I have the following language settings:<\/p>\n\n\n\n
select * from nls_session_parameters;<\/pre>\n\n\n\n
which provides:<\/p>\n\n\n\n
NLS_LANGUAGE ENGLISH NLS_TERRITORY AMERICA NLS_NUMERIC_CHARACTERS .,<\/pre>\n\n\n\n
This means that numbers are interpreted with a dot (.) as decimal indicator. I created a small table with numbers that shows this dot:<\/p>\n\n\n\n<\/figure>\n\n\n\n
It is possible to change the settings for a session. To that end, we fire next command:<\/p>\n\n\n\n
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ', ';<\/pre>\n\n\n\n
To check if numbers are now interpreted as having as decimal indicator being a comma, we try:<\/p>\n\n\n\n
insert into nummer(getal) values('1,45');<\/pre>\n\n\n\n
This looks successful. To check if ‘1,45’ is really inserted, we display the data:<\/p>\n\n\n\n<\/figure>\n\n\n\n
It is also possible to change the settings that determine the decimal point. These settings are derived from the computer one is working. On a windows machine, one may create a setting in the environmental variables:<\/p>\n\n\n\n<\/figure>\n\n\n\n
A variable NLS_LANG either exists or must be created. On my machine, it is AMERICAN_AMERICA.WE8MSWIN1252.<\/p>\n\n\n\n
Let us change this to DUTCH_THE NETHERLANDS.WE8MSWIN1252 <\/p>\n\n\n\n
It is also possible to set this variable in the registry:<\/p>\n\n\n\n<\/figure>\n\n\n\n
This is done. Then the machine is restarted. After a restart, we check if the comma is used as decimal separator. This is the indeed the case:<\/p>\n\n\n\n<\/figure>\n","protected":false},"excerpt":{"rendered":"
Numbers can be stored in Oracle according to different formats. On one hand, we have the American way, whereby numbers are stored with a dot (.) as decimal indicator. On the other hand, we have a comma (,) as decimal indicator. Let me provide my own Oracle instance. I have the following language settings: select […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-3239","post","type-post","status-publish","format-standard","hentry","category-nice-to-know"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3239"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3239\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3239"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n","protected":false},"excerpt":{"rendered":"