how can i read a text string like "31,432.99" as number 31432.99 ?
i tried using NLS_NUMERIC_CHARACTERS but it reads the strings with comma properly but does not read if i put the
decimal point.
thanks
alter session set NLS_NUMERIC_CHARACTERS= '.,';