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_...
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_...