Thanks for the response Waldemar. Actually, the reason I do the ALTER SESSION is so that TO_CHAR formats correctly using the 'G' and 'D' format mask characters. So, if I have a statement like
SELECT some_number, TO_CHAR(some_number, '999G999G999D999') FROM some_table I'm screwed because while the TO_CHAR format's correctly, the raw number (i.e. the 1st column in the select list) comes back with commas in it. Any other suggestions ? Steve -----Original Message----- From: Waldemar ¯urowski [mailto:[EMAIL PROTECTED] Sent: Tuesday, 12 August 2003 4:51 AM To: DBI Users List Cc: Steve Baldwin Subject: Re: DBD::Oracle - NLS and numbers W liście z pon, 04-08-2003, godz. 03:46, Steve Baldwin pisze: > I was intending to use ALTER SESSION SET NLS_TERRITORY='GERMANY' to Have You tried: ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' after setting NLS_TERRITORY to 'Germany'? Waldemar Żurowski
