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:30:08 +0000 (UTC)
Message-ID: <pan.2013.04.09.17.30.08_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:30:08 +0000 (UTC)
Message-ID: <pan.2013.04.09.17.30.08_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.
Of course, the "ORDER BY" is very useful, too. Just in case.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Tue Apr 09 2013 - 19:30:08 CEST