Oracle Database get source code

Oracle database get source code for package, procedure and functions using SQL query

 select * 
from dba_source 
where (name like ‘XXX%’ or name like ‘YYY%’)
order by owner, type, name, line;