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:
ORDER BY SKU Received on Tue Apr 09 2013 - 17:48:56 CEST
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