set feedback off
set heading off
set long 4000
SELECT dbms_metadata.get_ddl(‘PROFILE’,profile) FROM dba_profiles WHERE profile != ‘DEFAULT’