SELECT CASE WHEN :UOM = 'BX' THEN (Select :QTY / CA_QTY) ELSE :QTY FROM (select Item_qty_Bkd_qty CA_QTY from M_item_D1 where comp_code = 'A1' and cust_code = 'CLIFBAR' and item_code = '120004' and ITEM_QTY_BKD_LEV_NUM = 2)
|How can I exclude some wording in a like statement?||39||66|
|Remove Time Stamp from a Date field||4||41|
|Alter an update query which rounds||7||33|
|Oracle 10g - Select rows into colums||4||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!