Andrew Channels Dexter Pinion

Wherein I write some stuff that you may like to read. Or not, its up to you really.

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