Actually the best suggestion I had from a competent developer was that I the DBA should physically remove the keyboard from this SQL challenged individual.
This should go into Oracle WTF but that blog is not very active these days.
So here we go ... what do you think about this?
One of my developers has this coded in a single table select they are using thru sql developer:
SKU column is ( inventory part number ... VARCHAR2(20) )
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
I did note to this IT professional that many people like to go against character fields with the LIKE operator and that many people like to use greater than and less than against numeric fields MOSTLY ...