Dynamic Profile Creation Script

set serveroutput on
declare


cursor prof is
select dbms_metadata.get_ddl('PROFILE', profile) as profile
  from (select distinct profile 
          from dba_profiles) 
         where profile in ('<custom_profile_names>');



begin

dbms_output.enable(1000000);

 for i in prof loop
 
     
   dbms_output.put_line(i.profile);
   
 end loop;
   

end;
/