24 lines
986 B
SQL
24 lines
986 B
SQL
-- -----------------------------------------------------------------------------------
|
|
-- File Name : https://oracle-base.com/dba/script_creation/profile_ddl.sql
|
|
-- Author : Tim Hall
|
|
-- Description : Displays the DDL for the specified profile(s).
|
|
-- Call Syntax : @profile_ddl (profile | part of profile)
|
|
-- Last Modified: 28/01/2006
|
|
-- -----------------------------------------------------------------------------------
|
|
|
|
set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on
|
|
column ddl format a1000
|
|
|
|
begin
|
|
dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'SQLTERMINATOR', true);
|
|
dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'PRETTY', true);
|
|
end;
|
|
/
|
|
|
|
select dbms_metadata.get_ddl('PROFILE', profile) as profile_ddl
|
|
from (select distinct profile
|
|
from dba_profiles)
|
|
where profile like upper('%&1%');
|
|
|
|
set linesize 80 pagesize 14 feedback on verify on
|