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

7 votes186 views1 answer
Set sequence value oracle
SQL
15 votes181 views3 answers
Postgresql change column type
SQL
1 vote198 views1 answer
Mysql text to decimal
SQL
0 vote172 views1 answer
Oracle list dblink
SQL
0 vote172 views1 answer
Mysql count grouped rows
SQL
0 vote171 views1 answer
Order by monthly in sql
SQL
0 vote167 views1 answer
Create api project in visual studio 2019 and sql server
SQL
2 votes167 views1 answer
Mysql list users on ubuntu
SQL
1 vote217 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
10 votes186 views5 answers
Mysql create user
SQL