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

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

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

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to plsql

• How can you tell if a value is not numeric in Oracle? • Why do I get PLS-00302: component must be declared when it exists? • Split function in oracle to comma separated values with automatic sequence • PLS-00428: an INTO clause is expected in this SELECT statement • What is the max size of VARCHAR2 in PL/SQL and SQL? • PLS-00201 - identifier must be declared • Default Values to Stored Procedure in Oracle • How to call Oracle MD5 hash function? • Proper way of checking if row exists in table in PL/SQL block • PLS-00103: Encountered the symbol when expecting one of the following: