Oracle find text in functions

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

0 vote377 views1 answer
Excel export from sql using python
SQL
0 vote352 views1 answer
Dnsmasq.conf location macos
SQL
1 vote351 views1 answer
Importance of comment in mysql
SQL
17 votes430 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote409 views1 answer
Sql ssrs
SQL
32 votes378 views6 answers
How to change column name in sql
SQL
3 votes385 views1 answer
Start mysql server linux terminal
SQL
0 vote360 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote361 views2 answers
Mysql row_number() example
SQL
1 vote402 views1 answer
Tsql replace value in json
SQL