Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!87.79.20.101.MISMATCH!newsreader4.netcologne.de!news.netcologne.de!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: this is a candidate for oracle WTF but radio silence Date: Tue, 9 Apr 2013 17:30:08 +0000 (UTC) Organization: solani.org Lines: 21 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1365528608 27234 eJwVyckRwDAIBLCWwMCCyzFX/yVkoq9MwChXGNTWlo6w+kOkUCKlIffPicuvZ2lnVqqXe+qEfw3OEWc= (9 Apr 2013 17:30:08 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Tue, 9 Apr 2013 17:30:08 +0000 (UTC) User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) X-User-ID: eJwFwQERADEIAzBLwNOyySkc8y/hE3x0TiXBxMNr7fpUh9SKMZludAGXOnZKszY1zlR4rP87ORGZ Cancel-Lock: sha1:pZVTiaC/JNOiVaB04md8yx+z9Ow= X-NNTP-Posting-Host: eJwFwYkBADAEBLCVKOcZR6n9R2gCMbZ2NZhisTzNguZOd9ln9YainVbqeCHjhdyBJu6xEPogmxDa Xref: news.cambrium.nl 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.com