Oracle::simple Plsql, looping with cursor :selected table data:

Oracle::simple Plsql, looping with cursor selected table data

Oracle::simple Plsql, looping with cursor selected table data-Hi. . . to day i ll show you, a little bit thing about looping method, with selected table data.

DECLARE
cursor c is
select * from table;
c_rec c%rowtype;
BEGIN
    open c;
    loop
      fetch c into c_rec;
      exit when  c%notfound;
      
      /*Statements */
      /*examle */
      /*insert into table(col_a,col_b)values(c_rec.a,c_rec.b); */

    end loop;

:system.message_level := 5;
commit;
:system.message_level := 0;
END;