Oracle search code in packages

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 vote443 views1 answer
How to get number of months between 2 dates sql server
SQL
2 votes360 views1 answer
Sql column values comma separated
SQL
2 votes358 views1 answer
Sql count having
SQL
0 vote374 views1 answer
How to update date value in sql
SQL
2 votes357 views2 answers
How to DROP a table in mysql
SQL
2 votes354 views3 answers
How to pass password mysql command line
SQL
0 vote385 views1 answer
Last date for each user sql
SQL
0 vote361 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote377 views1 answer
Sql column contains special character
SQL
0 vote366 views2 answers
Disadvantages of stored procedures sql
SQL