Hi,
Considering that I have millions of records, what is the best option?
>>>Retrieval on a cursor and scan the cursor with a LOOP Ejemp:
CURSOR itm_cur IS
SELECT atribute
FROM table;
LOOP
FETCH itm_cur BULK COLLECT
INTO lcur_itm_cur /*itm_tbl */LIMIT 1000;
IF lcur_itm_cur.COUNT =0 THEN
GOTO exit_itm_cur;
END IF;
............................................................................................
<<exit_itm_cur>>
EXIT WHEN itm_cur%NOTFOUND;
COMMIT;
END LOOP;
CLOSE itm_cur;
OR
>>> INSERT INTO TABLE1
SELECT *FROM TABLE2
Thank you