01 August 2010

How to see code of store procedure from sqlplus

login as system or owner of stored procedure
set long 1000000;
select dbms_metadata.get_ddl('PROCEDURE','ADDSUBPARTITION') FROM dual;

No comments:

Post a Comment