67,515
社区成员
发帖
与我相关
我的任务
分享java中如何读取（查看）oracle里的存储过程SQL语句
java中如何读取（查看）oracle里的存储过程SQL语句
我要把所有的存储过程源码读取出来并显示，再作参数分析，现在请问如何把存储过程读取代码出来呢？
谢谢各位……
我要把所有的存储过程源码读取出来并显示，再作参数分析，现在请问如何把存储过程读取代码出来呢？
谢谢各位……
...全文
请发表友善的回复…
发表回复
Camelh 2007-11-28
- 打赏
- 举报
oracle 我没有用过,在Sybase中可以用sp_helptext来查看,我在网上帮你找了一下.你可以参考这个网页(http://www.dbforums.com/showthread.php?t=586814)
In Oracle, use sqlplus. Of course, since all the SQL Server sp_whatever
are just stored procedures, you could write your own SPs in Oracle.
To get the text of all your stored procedures:
set echo off feedback off pause off pagesize 0 linesize 90
column text format a90 wrapped fold_before
select text
from user_source
where type = 'PROCEDURE'
order by name, line;
clear columns
set feedback on pagesize 24 linesize 80
In Oracle, use sqlplus. Of course, since all the SQL Server sp_whatever
are just stored procedures, you could write your own SPs in Oracle.
To get the text of all your stored procedures:
set echo off feedback off pause off pagesize 0 linesize 90
column text format a90 wrapped fold_before
select text
from user_source
where type = 'PROCEDURE'
order by name, line;
clear columns
set feedback on pagesize 24 linesize 80
