Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
DECLARE CURSOR curs IS select a.colB from table2 where blahblahblah; curs_rec curs%rowtype; Begin FOR curs_rec IN curs LOOP insert into table1(colA, colB, colC) values (1, curs_rec, null); end loop; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('No more Data to be processed'); end;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!