Is there a workaround to this as decode does not seem to allow the use of greater than equal sign
I am trying to show the comment for any days beyond 4 days, not just 4 days.
decode(shipdate-orderdate,'4','This is unsatisfactory!') comments
Thanks in advance!
Where ShipDate - OrderDate >= 4;
You can try this code
select (case when shipdate-orderdated>=4 then 'Unsatisfactory!' else 'Satisfactory!' end)