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
