Re: this is a candidate for oracle WTF but radio silence
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 9 Apr 2013 17:18:53 +0000 (UTC)
Message-ID: <pan.2013.04.09.17.18.52_at_gmail.com>
On Tue, 09 Apr 2013 08:48:56 -0700, John Hurley wrote:
Date: Tue, 9 Apr 2013 17:18:53 +0000 (UTC)
Message-ID: <pan.2013.04.09.17.18.52_at_gmail.com>
On Tue, 09 Apr 2013 08:48:56 -0700, John Hurley wrote:
> AND sku > 'WLD-'
> AND SKU < 'WLE-'
> AND sku = 'WLD-559-5415'
These conditions are very interesting. I love the way your developer is thinking. Of course, he should also learn how to use the formatting tool available within SQL*Developer, so that the case of the column names is consistent within the SQL.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Tue Apr 09 2013 - 19:18:53 CEST