Extract the DDL for a profile

I needed to extract the DDL for a few profiles. This DDL was a quick and easy way to do it:

select dbms_metadata.get_ddl('PROFILE',a.profile) from dba_profiles a where a.profile = '' and rownum = 1;

Author: Dean Capps

Database consultant at Amazon Web Services.