在text檔裡,判斷多少筆數.－oracle園地

Jun 26 Thu 2008 11:23
在text檔裡,判斷多少筆數.

在text檔裡,判斷多少筆數.

                                11111
                                22222
                                33333
                                44444

begin
       text_io.get_line(v_in_file,v_linebuf);
       exit when v_linebuf is null;
       exception
       when no_data_found then
        text_io.fclose(v_in_file);

      exit;
    end;
     v_total_count := v_total_count+1;
end loop;