Oracle all_source package body

SELECT * FROM all_source    -- or user_source or dba_source
WHERE upper(text) LIKE '%MY TEXT%'
	AND TYPE IN ('FUNCTION','PROCEDURE','PACKAGE')
ORDER BY owner, name, type, line;

Similar codes

4 votes196 views5 answers
Primary key
SQL
21 votes188 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
2 votes212 views2 answers
Python escape string for sql
SQL
6 votes194 views2 answers
Clear a table in mysql
SQL
3 votes182 views2 answers
Create schema postgres
SQL
0 vote187 views2 answers
Plsql function that return a table
SQL
22 votes201 views3 answers
SQL CHEATSHEET
SQL
6 votes190 views1 answer
To count number of rows in SQL table
SQL
0 vote186 views1 answer
Mysql date time string format python
SQL
5 votes186 views1 answer
Mysql last day of next month
SQL