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:28:58 +0000 (UTC)
Message-ID: <pan.2013.04.09.17.28.58_at_gmail.com>
On Tue, 09 Apr 2013 17:18:53 +0000, Mladen Gogala wrote:
>
> 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.
Date: Tue, 9 Apr 2013 17:28:58 +0000 (UTC)
Message-ID: <pan.2013.04.09.17.28.58_at_gmail.com>
On Tue, 09 Apr 2013 17:18:53 +0000, Mladen Gogala wrote:
> 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.
This can be compared with artillery: one shell falls short, the other goes over the target and the third one hits the target. You, as the DBA, must be delighted by such a spectacular barrage.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Tue Apr 09 2013 - 19:28:58 CEST