Re: Oracle Magazine Blooper

Rob C wrote:

> If you have the May/June issue turn to p18
> or here: http://otn.oracle.com/oramag/oracle/04-may/o34briefs.html
>
> Have a look at the "sample code - Condition-based column in query"
> and try to have a laugh.
>
> man, talking about blissful ignorance.......

And for anyone interested in a possibly more reasonable approach:

SELECT parameter,
CASE WHEN parameter < 1000 THEN 'C' ELSE 'P' END AS BAND FROM parameter_table;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)