Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- begin BEGIN
- OPEN RC_TABLE0 FOR
- select (
- SELECT DISTINCT listagg(ITEM_ID,', ') within group(order by ITEM_ID) FROM TB_PL_M_WRKORD WRKOD
- WHERE 1 = 1
- AND WO_DATE = '20181012'
- AND WRKOD.ITEM_ID NOT IN (SELECT ITEM_ID FROM TB_CM_M_FERT_COST_CHK FERT)
- AND WC_ID = 'U'
- ) into promena from dual;
- end;
- dbms_output.put_line('test'||promena);
Add Comment
Please, Sign In to add comment