1、Oracle 程序包查询
SELECT DISTINCT NAME FROM DBA_SOURCE WHERE type = 'PACKAGE' ORDER BY NAME;
2、Oracle程序包中函数、存储过程源码查询
SELECT * FROM DBA_SOURCE WHERE TYPE = 'PACKAGE BODY';
1、Oracle 程序包查询
SELECT DISTINCT NAME FROM DBA_SOURCE WHERE type = 'PACKAGE' ORDER BY NAME;
2、Oracle程序包中函数、存储过程源码查询
SELECT * FROM DBA_SOURCE WHERE TYPE = 'PACKAGE BODY';