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';
结果为:
时间: 2024-08-29 07:21:08