Oracle存储过程开发

---查询所有的存储过程
select t.OBJECT_ID,t.OBJECT_NAME,t.LAST_DDL_TIME,t.status
from user_objects t 
where object_type='PROCEDURE'
order by t.status;
---查看某个存储过程的文本内容
select text from user_source where name='P_BI_RQ_CX' and type='PROCEDURE';
---查看某个存储过程有哪些参数
select * from ALL_ARGUMENTS where object_name='P_BI_RQ_CX' and owner='SHINEYUE40_JSYT';