在sqlplus 中如何查询数据库中的存储过程和job!

[xzwsun]

请问通过什么命令可以查询数据库中的已有的存储过程和job!

[zhpsam109]

SELECT * FROM user_objects WHERE OBJECT_TYPE='PROCEDURE'

[mschen]

select * from user_source
where type='procedure';

select * from all_source
where type='procedure';

select * from dba_source
where type='procedure';

[zhpsam109]

SELECT * FROM User_Jobs

[boydgmx]

select * from all_jobs;
SELECT OWNER,OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE='PROCEDURE';