Hello,
with german NLS parameters, when exporting as insert statements there was bug 7322676 (Dots are used as value separator when doing insert export). This is fixed now, but when creating an insert I get 123,4 for american 123.4. This means I still cannot use the generated Insert
INSERT INTO tab (charcol, numcol)
VALUES ('text',123,4);
ORA-00913: too many values
The only secure way in my opinion is the one we use when generating inserts by PL/SQL:
INSERT INTO tab (charcol, numcol)
VALUES ('text',1234/10);
Our package simply generates a division for the decimals. This is independent from the NLS parameters of the target database.
Regards
Marcus