Dynamic Profile Creation Script
Jump to navigation
Jump to search
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; /