I am looking for a way to implement
case when (ord - (select sum(shipping) from shipping where item = 'SOME ITEM')) >= (0)
THEN (select sum(shipping) from shipping where item = 'SOME ITEM') ELSE 'ERROR' END AS "QTY"
where IN_ITEM = 'SOME ITEM';//
if I replace ERROR with a number, i the query works, right now im getting error
ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
00932. 00000 - "inconsistent datatypes: expected %s got %s"
Error at Line: 3 Column: 97