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 votes104 views1 answer
Mysql load data infile csv
SQL
0 vote155 views2 answers
Php convert dbf to mysql
SQL
0 vote132 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote138 views1 answer
Access mysql database docker container shell
SQL
0 vote140 views1 answer
Sql mod even odd
SQL
6 votes143 views1 answer
How to count number of rows in sql
SQL
1 vote203 views1 answer
Concat first name and last name in mysql
SQL
0 vote182 views3 answers
Characters found after end of sql statement
SQL
0 vote149 views1 answer
Original Query
SQL
0 vote132 views1 answer
Console output pl sql
SQL