I have been assigned to the task.
Task :- In one table , I have 10 million records and I need to export table data into a CSV files/Text files but the condition is that(I need to export into 5 files ,each file should contain 2 million records)
1) 1 to 2 million records should be inserted into 1 file
2) after 2 million records inserted , it has to create a separate file to insert 2 million records to 4 millions record and so on the process should continue until 10 million records

Note :- This has to be solve by using procedures only(PL/SQL)

declare
  cursor cur is 
    select * from ...;
  
  type cur_rec is table of cur%rowtype index by pls_integer;
  recs cur_rec;
  
  row_count pls_integer := 0;
begin
  open cur;
  
  loop
  
    if mod ( row_count, 2000000 ) = 0 then
      /* close old file, open new */
    end if;    
    
    fetch cur bulk collect 
    into recs limit 1000;
    
    exit when recs.count = 0;
    
    row_count := row_count + recs.count;
    
    /* write to the file */
    
  end loop;
    
  close cur;
end;
/