CASE can work as a PL/SQL construct whereas DECODE can work as a function inside SQL only. CASE can be an efficient substitute for IF-THEN-ELSE in PL/SQL.

Friends,I'm trying to write a select statement that ends like this:and sc.customer_name in (DECODE(shipto,'0',sc.customer_name,shipto));The trouble is that shipto contains a comma delimted list. I ...