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

User · Answer

You can also use DBMS METADATA   select dbms metadata get ddl  FUNCTION    FGETALGOGROUPKEY    PADCAMPAIGN    from dual

User · Answer

SELECT text  FROM all source where name    FGETALGOGROUPKEY  order by line   alternatively   select dbms metadata get ddl  FUNCTION    FGETALGOGROUPKEY   from dual

User · Answer

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

[oracle] How to see PL/SQL Stored Function body in Oracle

Examples related to oracle

Examples related to plsql