How do I convert a list of values into a string?
710073Oct 29 2009 — edited Oct 30 2009Does anyone know how to convert the below into a string form?
CURSOR WBReceive IS
SELECT 'D' record_id, 'CAS' org_code, 'DIEBANK' dept, 'RECEIVE' tran_type,
customercode, originalcustomerlotnumber intersil_lot_no, device, appid, PACKAGE,
nvl (waferdiesquantity, startquantity) die_qty, waferquantity, lottype,
processspeed, shipfrom, lotobject, lotorderid,
substr (txntime, 3, 6) tran_date, substr (txntime, 10, 6) tran_time
FROM edi_rpt_temp
WHERE customercode = pcust AND transtype = 'WBReceive';
My customercode list is HAT,ELS,ELX,HUS & ISL
If I declare pcust := 'HAT' then customercode that are not HAT will not be captured.
How do I turn this info into a string and be able to capture all info related to above customercode list?