oracle 游标的用法之一

游标查询内容有参数

    declare cursor mycursor is 
    select A.a1, A.a2 from tableA A where A.a1=''||aID||'' order by <span style="font-family: Arial, Helvetica, sans-serif;">A.a2</span><span style="font-family: Arial, Helvetica, sans-serif;"> desc;</span>
    
    begin
    for c in mycursor 
      loop
        BEGIN
        --循环的内容

           insert into B select c.a1||c.a2 from dual
        END;
      end loop;
    end;