December 17, 2001
Quality SQL
Here is some quality SQL;
SELECT decode(customer_class_code, '', 'Distributor', customer_class_code)
FROM ra_customers
/
Someone should really learn how to use 'NVL'. Mind you, as I said to Mr Kelly when we found that code, this is the reason people like us are never going to be short of work.
Posted by Andy Todd at December 17, 2001 03:44 PM
Comments