Object source code


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

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
/