select text from all_source where name = '存储过程名';
例如建立存储过程的语句为:
CREATE OR REPLACE PROCEDURE EMP_COUNT
AS
V_TOTAL NUMBER(10);
BEGIN
SELECT COUNT(*) INTO V_TOTAL FROM EMP;
DBMS_OUTPUT.PUT_LINE('雇员总人数为:'||V_TOTAL);
END;
执行查询语句为:
select text from all_source where name = 'EMP_COUNT';
结果为: