Search This Blog

Total Pageviews

Tuesday, 4 July 2023

Oracle metadata for FUNCTION


Oracle metadata for FUNCTION




set linesize 300 pagesize 300

col USERNAME for a20 
col PASSWORD_LIFE_TIME for a20

SET LONG 10000 LONGCHUNKSIZE 10000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON
with x as 
(
  SELECT owner, object_name, object_type
    FROM dba_objects
  WHERE 1=1
-- and owner LIKE 'SYS'
    AND object_type IN ('PROCEDURE',  'FUNCTION')
and object_name in ('ORA12C_STRONG_VERIFY_FUNCTION','ORA_COMPLEXITY_CHECK')
)
SELECT  DBMS_METADATA.get_ddl (x.object_type, x.object_name, x.owner) as ddlcode FROM x;


No comments:

Oracle DBA

anuj blog Archive