How to see PL/SQL Stored Function body in Oracle

Question

I have a stored function in Oracle database pAdCampaign.fGetAlgoGroupKey. How to see the code of this function.?

Answer 1

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

Answer 2

SELECT text  FROM all_source where name = 'FGETALGOGROUPKEY' order by line 

alternatively:

select dbms_metadata.get_ddl('FUNCTION', 'FGETALGOGROUPKEY') from dual;