declare
     a varchar2(50) := 'AUGUSTO NAVARRO'; -- NAVARRO AUGUSTO
     c number := 0;
     d varchar2(50);
     e varchar2(50);
     p_name varchar2(50):='AUGUSTO NAVARRO';
     cursor cur is(
       SELECT 
        NAME
         FROM base_table
        WHERE UPPER(NAME) like UPPER(a)
          );
   begin
     a := '%' || replace(a, ' ', '%') || '%';
     dbms_output.put_line('name ' || a);
   
     SELECT count(*)
       into c
       FROM base_table
      WHERE UPPER(NAME) like UPPER(a)
        AND RECORD_STAT = 'O';
   
     if c = 0 then     
       d := substr(a, instr(p_name, ' ') + 1);
       e := substr(a, 1, instr(p_name, ' ')+1);
       dbms_output.put_line('first name ' || d);
       dbms_output.put_line('second name ' || e);
       a:=d  || e;
       --a := '%' || replace(a, ' ', '%') || '%';
       dbms_output.put_line('full name ' || a);
     end if;
   
     for rec in cur loop
     
       dbms_output.put_line(rec.name);
       c := c + 1;
       if c = 50 then
         exit;
       end if;
     end loop;
   end;