如果新写的存储过程覆盖了原来的存储过程,这个时候可以这样子查询之前存储过程的脚本
在系统用户下创建临时表
一个小时前,时间为3600秒
create table TEMP
as
select * from all_source as of timestamp (systimestamp -interval'3600'second)
where TYPE = 'PROCEDURE' and owner = 'SCOTT' and Name = 'SP';
查询脚本
select text from TEMP
where name= SP and owner ='SCOTT'
order by line;