I’m struggling with a problem related to decimal separator.
Independently on which NLS_NUMERIC_CHARACTERS I’m setting (’.,’/’,.’/’ ,’/’ .’)
The following query always returns: 1000,5 (with comma)
SELECT 2001/2 FROM DUAL;
This problem is driving me crazy cause I often have to export records in INSERT INTO format and everytime a coloumn has a decimal value, I fall in this defect:
INSERT INTO TABLE (SINGLE_COLOUMN) VALUES (1000,5);
That, obviously, ends up with error “ORA-00913: too many values”.
Is there something I have to modify/edit/configure to prevent this behaviour?
Thank you in advance.