Generate DDL Script (A Faster way)

Generate DDL Script (A Faster way)


SELECT dbms_metadata.get_ddl(Object_type,object_name,OWNER)
FROM all_objects
WHERE object_name LIKE 'XX%'
AND Object_type IN ( 'TABLE' ,'PACKAGE' , 'PROCEDURE' ,'FUNCTION' ,'SEQUENCE' ,'DIRECTORY' ,'TRIGGER' )
Order by Object_type

Query to Get All Concurrent Program & Executable Name, Description and More

Concurrent Program & Executable Name, Description


SELECT fcp.user_concurrent_program_name ,
  fcp.description Description,
  fef.executable_name exe_Name,
  fef.description Exe_Description,
  fef.execution_file_name execution_file_name,
  DECODE (fe.execution_method_code , 'A', 'Spawned' , 'B', 'Request Set Stage Function' , 'E', 'Perl Concurrent Program' , 'H', 'Host' , 'I', 'PL/SQL Stored Procedure' , 'J', 'Java Stored Procedure' , 'K', 'Java Concurrent Program' , 'L', 'SQL*Loader' , 'M', 'Multi Language Function' , 'P', 'Oracle Reports' , 'Q', 'SQL*Plus' , 'S', 'Immediate' , 'Other')execution_method
FROM fnd_executables_form_v fef,
  fnd_concurrent_programs_vl fcp ,
  fnd_executables fe
WHERE fcp.APPLICATION_ID=fef.APPLICATION_ID
AND fef.EXECUTABLE_ID   =fcp.EXECUTABLE_ID
AND fef.EXECUTABLE_ID   =fe.EXECUTABLE_ID
--AND fef.executable_name='XX%'---Your Executable Name
--AND fcp.user_concurrent_program_name LIKE 'XX%' -- Your Concurrent Program name

BI/ XML Publisher Excel Template

Oracle Link.
https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T571887.htm