Ficha 12_ex4_5

DO $$ DECLARE
            v_name cust.c_last%TYPE;
         BEGIN
            FOR i IN 1..3
            LOOP
               FOR j IN 1..3000
               LOOP
                 EXECUTE
                    'select c_last from cust
                     where c_w_id=1
                     and c_d_id='||i||' and c_id='||j
                 INTO v_name;
               -- Do something with v_name
             END LOOP;
          END LOOP;
END; $$;
DO

-- Time: 320.927 ms

-- 5. Tune the PL/SQL block above. Consider only the lines related to the SELECT command.

DO $$
DECLARE
  v_name cust.c_last%TYPE;
BEGIN
      FOR i IN 1..3
      LOOP
        FOR j IN 1..3000
        LOOP
            SELECT c_last INTO v_name FROM cust
              WHERE c_w_id=1
              AND c_d_id=i AND c_id=j;
       END LOOP;
    END LOOP;
END;
$$;
DO
-- Time: 35.848 ms