There is no expression error in the application used to submit SQL, but when working in SQL Developer

Question

When I wrote the code below in Oracle SQL Developer, it works great, when you paste this code into the Webwise tool that we use to create reports, are these errors that indicate a loss of experience? Usually we just copy and paste the code and it works great ...

The code:

select o.wh_id, o.bill_to_code, (case when d.pick_area like 'GPS%' then 'GPS' else d.pick_area end) as pick_area, count(*) as OUC from t_order o INNER JOIN t_pick_detail d on o.order_number = d.order_number where o.wh_id = '~wh_id~' group by o.wh_id, o.bill_to_code, (case when d.pick_area like 'GPS%' then 'GPS' else d.pick_area end) order by o.bill_to_code; 

Answer 1

To end this post, delete ';' to ensure its performance.

As an added note. There may be a different interpreter in the underlying mechanism that actually runs your SQL, and in some cases this will cause problems. When working with various tools that interact with the same platform, make sure that the syntax is correct for the documentation of this system.

Answer 2

When you copy the paste code, be sure to check your "and" "- many times, inverted commas are messed up.