12带参数的游标

/*
* 定义游标时，可以带参数
*/
--select * from T_classinfo; 

declare
  cursor cs_big is
    Select * From T_Classinfo where parentid = 0 order by classid asc;

  cursor cs_small(param_id number) is
    Select *
      From T_Classinfo
     where parentid = param_id
     order by classid asc;

  v_childCount number;
begin

  for v_big in cs_big loop
    dbms_output.put_line(v_big.classname);
  
    --循环小类别
    --获取小类别的总数量
    select count(1)
      into v_childCount
      From T_Classinfo
     where parentid = v_big.classid;
  
    for v_small in cs_small(v_big.classid) loop
    
      if v_childCount != cs_small%RowCount then
        dbms_output.put_line('   ├' ||v_small.classname);
      else
        dbms_output.put_line('   ∑' ||v_small.classname);
      end if;
    end loop;
  end loop;
end;