I was asked to do some data-mining on a DB which has it's decimal separator set as a comma. This is mucking up many of my data-mining/statistical analysis programs in R, Perl, etc.. The users have no objections to me changing this setting globally, rather doing it on a per-session basis. Can this be done, and how? I was skimming Oracle docs, and they seemed to imply that you could only change it on a per-session basis or on database creation.