I'm having dificulties understanding the way Oracle handles regional settings.
Suppose I have the following query:
INSERT INTO table (price) VALUES (0,23)
Then Oracle returns a "too many values" error message.
Since I am a developer, not the DBA, there is no chance to change Oracle NLS's settings to set the comma character as the decimal places delimiter. My software has to work with Spanish regional settings, ie: "," as the decimal places separator and "." as thousands separator.
Is there any way to specify in a SQL statement that 0,23 is a number and not two separate values, without altering any settings in the Server?