Skip to main content

Hello,

Could you please give me advice on this problem. My task was to add new column SUM which will count values in two columns and in this column are decimal values with a dot, but I want decimal values with a comma, how can I change it? This is my query:

“SELECT :QUANTITY + :QTY_WAIV_DEV_REJ 
FROM INVENTORY_VALUE_PART_LEVEL_EXT”

 

I tried this command:

 

“SELECT REPLACE(TO_CHAR(:QUANTITY, '99999999.9'), '.', ',') + 
       REPLACE(TO_CHAR(:QTY_WAIV_DEV_REJ, '999999999'), '.', ',')
FROM INVENTORY_VALUE_PART_LEVEL_EXT  “

 

in SQL works, but in IFS it didnt retrieves any data.

Hi,

It all depends of course on the NLS_LANGUAGE and regional settings regarding which decimal separator to use, so I leave that out. But in your case I think you first need to convert back to number format before adding the two values.

Reply


Terms & ConditionsCookie settings