Oracle search source code

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 vote383 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
-1 vote345 views2 answers
Get day in sql
SQL
0 vote344 views1 answer
We are intrested to work with your organization
SQL
0 vote374 views1 answer
What is top n result in sql
SQL
3 votes358 views1 answer
Sql online test questions and answers
SQL
5 votes348 views1 answer
Sql use database
SQL
2 votes390 views2 answers
Mysql does sentence contain word
SQL
2 votes348 views1 answer
Sql missing records from another table
SQL
3 votes360 views2 answers
Enter mysql command line
SQL
0 vote378 views1 answer
Postgresql like
SQL