Guest User

Untitled

a guest
Oct 19th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. begin BEGIN
  2. OPEN RC_TABLE0 FOR
  3. select (
  4.  
  5. SELECT DISTINCT listagg(ITEM_ID,', ') within group(order by ITEM_ID) FROM TB_PL_M_WRKORD WRKOD
  6. WHERE 1 = 1
  7. AND WO_DATE = '20181012'
  8. AND WRKOD.ITEM_ID NOT IN (SELECT ITEM_ID FROM TB_CM_M_FERT_COST_CHK FERT)
  9. AND WC_ID = 'U'
  10.  
  11. ) into promena from dual;
  12.  
  13. end;
  14.  
  15. dbms_output.put_line('test'||promena);
Add Comment
Please, Sign In to add comment