SQL> declare
  2    txt  clob;
  3    idx  integer;
  4    nl   varchar2(2) := chr(10);
  5  begin
  6    txt := 'Hello,'||nl||'I am Michel.'||nl||'Have a nice day!'; -- replace by your clob loading
  7    idx := instr(txt,nl);
  8    loop
  9      exit when idx = 0;
 10      dbms_output.put_line(substr(txt,1,idx-1));
 11      txt := substr(txt, idx+1);
 12      idx := instr(txt,nl);
 13    end loop;
 14    if txt is not null then dbms_output.put_line(txt); end if;
 15  end;
 16  /
Hello,
I am Michel.
Have a nice day!

PL/SQL procedure successfully completed.

SQL> declare
  2    txt  clob;
  3    line varchar2(4000);
  4    lg   integer;
  5    i1   integer;
  6    i2   integer;
  7    nl   varchar2(2) := chr(10)||chr(13);
  8    nllg integer := length(nl);
  9  begin
 10    txt := 'Hello,'||nl||'I am Michel.'||nl||'Have a nice day!'; -- replace by your clob loading
 11    lg  := length(txt);
 12    i1  := 1;
 13    loop
 14      i2 := instr(txt,nl,i1);
 15      exit when i2 = 0;
 16      dbms_output.put_line(substr(txt,i1,i2-i1));
 17      i1 := i2+nllg;
 18    end loop;
 19    if i1 < length(txt) then dbms_output.put_line(substr(txt,i1)); end if;
 20  end;
 21  /
Hello,
I am Michel.
Have a nice day!

PL/SQL procedure successfully completed.

ID,Term,Recruiter
A01,202420,Name 1
A0102,202420,Name 2
A010203,202420,Name 3
A01020304,202420,Name 4
A01,202420,Name 5
A02,202420,Name 6
A03,202420,Name 7
A04,202420,Name 8
A05,202420,Name 9

CREATE TABLE FILE_CONTENTS
(
  ID        VARCHAR2(10 CHAR),
  TERM      VARCHAR2(6 CHAR),
  RECRUITER VARCHAR2(50 CHAR)
)

declare
  
  DestinationClob   clob;
  SourceBlob        blob;
  DestinationOffset integer := 1;
  SourceOffset      integer := 1;
  LanguageContext   integer := dbms_lob.default_lang_ctx;
  Warning           integer;
  Counter           number  := 0;
  Value1            varchar2(10);
  Value2            varchar2(6);
  Value3            varchar2(50);


  begin
    select file
      into SourceBlob
      from file_table
        where id = '1';
    
    dbms_lob.createTemporary(lob_loc => DestinationClob, 
                             cache   => false);

    dbms_lob.converttoclob(dest_lob     => DestinationClob,
                           src_blob     => SourceBlob,
                           amount       => dbms_lob.lobmaxsize,
                           dest_offset  => DestinationOffset,
                           src_offset   => SourceOffset,
                           blob_csid    => dbms_lob.default_csid,
                           lang_context => LanguageContext,
                           warning      => Warning);

    for i in (select regexp_substr(txt, '[^\,]+', 1, level) txt,
                     level line
                from (select dbms_lob.substr(DestinationClob, 4000, 1) txt
                        from dual)
                  connect by level <= regexp_count(DestinationClob, '[^\,]+'))
      loop
        case
          when i.line = 1
            then
              Value1 := i.txt;
                  
          when i.line = 2
            then
              Value2 := i.txt;
                  
          when i.line = 3
            then
              Value3 := i.txt;
                  
            else
              Value1 := '1';
        end case;
            
        counter := counter + 1;
            
        if Counter = 3
          then
            Counter := 0;
                
            insert into file_contents
              (id,
               term,
               recruiter)
           
              values
                (Value1,
                 Value2,
                 Value3);
        end if;
            
        dbms_output.put_line(i.txt||' '||i.line);
      end loop;
      
      commit;

  end;

declare
  
  DestinationClob clob;
  SourceBlob      blob;
  DestOffset      integer := 1;
  SourceOffset    integer := 1;
  LanguageContext integer := dbms_lob.default_lang_ctx;
  Warning         integer;

  begin
    select file
      into SourceBlob
      from file_table
        where id = '1';
    
    dbms_lob.createTemporary(lob_loc => DestinationClob, 
                             cache   => false);

    dbms_lob.converttoclob(dest_lob     => DestinationClob,
                           src_blob     => SourceBlob,
                           amount       => dbms_lob.lobmaxsize,
                           dest_offset  => DestOffset,
                           src_offset   => SourceOffset,
                           blob_csid    => dbms_lob.default_csid,
                           lang_context => LanguageContext,
                           warning      => Warning);

    for i in (select *
                from (select value_1,
                             value_2,
                             value_3
                        from (select regexp_substr(txt, '[^\,]+', 1, level) txt,
                                     level line
                                from (select dbms_lob.substr(DestinationClob, 4000, 1) txt
                                        from dual)
                                connect by level <= regexp_count(DestinationClob, '[^\,]+'))
                          pivot (min(txt) for line in (1 as value_1, 2 as value_2, 3 as value_3))))
      loop
        dbms_output.put_line(i.value_1||i.value_2);
      end loop;
      
      commit;

  end;