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 vote184 views1 answer
Sql case when exists in another table
SQL
0 vote309 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote192 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote193 views2 answers
Plsql function that return a table
SQL
0 vote181 views1 answer
How to get n result in sql
SQL
0 vote194 views1 answer
Check if has alpha characters sql
SQL
0 vote187 views1 answer
Sql select all tables from database change url
SQL
2 votes170 views1 answer
Mysql list users on ubuntu
SQL
6 votes243 views3 answers
Mysql remove user privileges
SQL
0 vote188 views4 answers
How to drop all tables in sql
SQL