Monday, January 18, 2016

How to Get DDL of the Procedure or any object in oracle

use below sql to get the DDL of a specific object:

set long 32000
set long 90000
set heading off;
set echo off;
set pages 1000;
SQL> spool object_name.sql

SQL> select dbms_metadata.get_ddl('object_type','object_name','Owner of the object') from dual;
SQL> spool off

Thanks...

No comments:

Post a Comment

PostgreSql: Useful Commands-

 1)   ************************* Users ***************************  -- List of users with roles assigned: SELECT usename AS role_name,   CASE...