ORA-00904: "SAFE_DIVISION": invalid identifier - how to get a workaround ?
Hi all,
In TOAD, I am running the SQL provied by someone and it is giving error."ORA-00904: "SAFE_DIVISION": invalid identifier" Is there a alternate way to write this SQL. Please comment off the last two statements to run in your environment. There must some simple way to run this SQL. Thanks
SELECT ROUND(SAFE_DIVISION((DEMAND - FORECAST), DEMAND, 0), 4) * 100 AS BIAS FROM (SELECT SUM(NVL(FORE_3,0)) AS FORECAST, SUM(NVL(greatest(nvl(pseudo_sale,nvl(actual_quantity, src_actual_quantity))*(1 + nvl(demand_fact,0)),0), 0)) AS DEMAND
FROM
Dem7302.MDP_MATRIX, dem7302.SALES_DATA BRANCH_DATA WHERE
MDP_MATRIX.ITEM_ID = BRANCH_DATA.ITEM_ID AND MDP_MATRIX.LOCATION_ID = BRANCH_DATA.LOCATION_ID AND MDP_MATRIX.PREDICTION_STATUS = 1