如何在Oracle中查看PL/SQL存储功能主体 [英] How to see PL/SQL Stored Function body in Oracle
本文介绍了如何在Oracle中查看PL/SQL存储功能主体的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在Oracle数据库pAdCampaign.fGetAlgoGroupKey中有一个存储函数. 如何查看此功能的代码.
I have a stored function in Oracle database pAdCampaign.fGetAlgoGroupKey. How to see the code of this function.?
推荐答案
如果是软件包,则可以使用以下命令获取源代码:
If is a package then you can get the source for that with:
select text from all_source where name = 'PADCAMPAIGN'
and type = 'PACKAGE BODY'
order by line;
Oracle不会单独存储子程序的源代码,因此您需要仔细查看软件包的源代码.
Oracle doesn't store the source for a sub-program separately, so you need to look through the package source for it.
注意:我假设您在创建该软件包时没有使用双引号,但是如果这样做了,请使用
Note: I've assumed you didn't use double-quotes when creating that package, but if you did , then use
select text from all_source where name = 'pAdCampaign'
and type = 'PACKAGE BODY'
order by line;
这篇关于如何在Oracle中查看PL/SQL存储功能主体的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文