Query Source Code of a Function or Procedure in Oracle

Use the following query to read the source code.

select * from all_source where name = 'XXXX_XXX_XX_X';

All_Source keeps the text source of all stored objects in ORACLE, that are accessible to logged in user.

We can filter based on columns :

1. Name - Name of object
2. TYPE - Type of object. e.g. Function, procedure, Trigger, Package, etc..