Object source code


set heading on;
set echo off;
Set pages 999;
set long 90000;
 
select dbms_metadata.get_ddl('&OBJECT_TYPE','&OBJECT_NAME','&OBJECT_OWNER') from dual
/