如何在 Oracle 中查看 PL/SQL 存储函数体

2021-12-24 00:00:00 oracle plsql

我在 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;

相关文章