Quote:
Originally posted by jmodic
Ah. There is a concept called "National Language Support" in Oracle. And as you might know, not everyone's got that set to American/America or something like that, where NLS_NUMERIC_CHARACTERS by default is set to '.,'. There are many countries that uses just the opposite combination - "." for thousands separator and "," as decimal character. And I can't see how you drived number "40,0195313" to mean "400195313" - it simply can't be, even if "," would be thousands sepparator. Everyone that saw this number must have clearly realised that ',' could only be a decimal character here, no other possibility. Don't you think? (And everyone could also noticed that I mistyped the 8K block size number in that query - used 8196 instead of 8192). :o
I quite really didnt notice u mis typed 8K as 8196..