SELECT text FROM all_source WHERE OWNER='用户名' AND TYPE='PROCEDURE' and NAME='过程名';注意: 单引号里要大写.
set heading off set echo off set feedback off set pages off set long 90000 SEELCT DBMS_METADATA.GET_DDL('PROCEDURE','YOURPROCEDURENAME') FROM USER_OBJECTS WHERE OJBECT_TYPE='PROCEDURE' AND OBJECT_NAME='YOURPROCEDURENAME';
FROM all_source
WHERE OWNER='用户名' AND TYPE='PROCEDURE' and NAME='过程名';注意: 单引号里要大写.
set echo off
set feedback off
set pages off
set long 90000
SEELCT DBMS_METADATA.GET_DDL('PROCEDURE','YOURPROCEDURENAME') FROM USER_OBJECTS WHERE OJBECT_TYPE='PROCEDURE' AND OBJECT_NAME='YOURPROCEDURENAME';