POLISH CURRENCY PROBLEM
540230Dec 5 2006 — edited Dec 5 2006Hi ^^
POLISH CURRENCY FORMAT(099.999.999,00) IS LIKE THIS
CHARACTER
177,96
870,80
1560,00
AND I WANT CONVERSION IT
NUMBER
CHARACTER
177.96
870.80
1560.00
I did like this it , it has no error ~
SELECT TO_NUMBER(REPLACE ( NVL(ATTRIBUTE2,'0'), ',' , '.'))
FROM AP_INVOICE_DISTRIBUTIONS_ALL
WHERE LINE_TYPE_LOOKUP_CODE = 'TAX' ;
but SUM it error occured !!
SELECT SUM( TO_NUMBER(REPLACE ( NVL(ATTRIBUTE2,'0'), ',' , '.')) )
FROM AP_INVOICE_DISTRIBUTIONS_ALL
WHERE LINE_TYPE_LOOKUP_CODE = 'TAX' ;
ORA-01722:invalid number
HELP ME ^^ !!
Message was edited by:
jake