/SQL/Oracle search stored procedures for text

Oracle search stored procedures for text

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

1 vote139 views2 answers
ImportError: No module named mysql.connector
SQL
2 votes139 views1 answer
Pandas to sql index
SQL
1 vote164 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote132 views2 answers
How to get json data mysql
SQL
0 vote144 views1 answer
Get server date mysql
SQL
2 votes159 views1 answer
Postgresql transaction
SQL
0 vote329 views1 answer
Power bi connect to postgresql
SQL
5 votes149 views3 answers
Bash: mysql: command not found
SQL
1 vote134 views1 answer
Moodle query item quiz
SQL
3 votes183 views3 answers
Restart mysql mac
SQL