Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <<nullen>>
- FOR r IN (
- SELECT vqm_qot_id, FSDQ_SUP_XPRESSFEED, fsdq_tickersymbol FROM fsdq, vqm WHERE vqm.vqm_vqot_id IS NULL AND FSDQ_SUP_XPRESSFEED = vqm.vqm_qot_sup_xpressfeed)
- LOOP
- FOR e IN c_exc
- LOOP
- BEGIN
- UPDATE vqm
- SET vqm.vqm_vqot_on =(SELECT VQOT.VQOT_ON FROM vqot WHERE VQOT.VQOT_ON = r.fsdq_tickersymbol || '.'|| e.vem_vexc_shortname),
- vqm.vqm_vqot_id =(SELECT VQOT.VQOT_id FROM vqot WHERE VQOT.VQOT_on = r.fsdq_tickersymbol || '.'|| e.vem_vexc_shortname)
- WHERE
- vqm.vqm_qot_id = r.vqm_qot_id;
- COMMIT;
- EXCEPTION
- WHEN NO_DATA_FOUND THEN
- NULL;
- END;
- END LOOP;
- END LOOP;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement