this is a candidate for oracle WTF but radio silence

From: John Hurley <johnthehurley_at_gmail.com>
Date: Tue, 9 Apr 2013 08:48:56 -0700 (PDT)
Message-ID: <ac2fb88c-efc9-413a-b032-2c8be6345813_at_q6g2000yqa.googlegroups.com>



One of my developers has this coded in a single table select they are using thru sql developer:

SKU is ( inventory part number ... VARCHAR2(20) )

 SELECT sku,

         site_id,
         site_and_sku,
         qty_oh,
         qty_demand
    FROM schema_name.table_name
   WHERE     qty_oh > 0
         AND (qty_oh - qty_demand < 5)
         AND qty_demand < qty_oh
         AND sku > 'WLD-'
         AND SKU < 'WLE-'
         AND sku = 'WLD-559-5415'

ORDER BY SKU Received on Tue Apr 09 2013 - 17:48:56 CEST

Original text of this message