/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

0 vote287 views1 answer
Sql server system messeges
SQL
2 votes304 views2 answers
Calculate percentage in sql
SQL
1 vote272 views1 answer
List index mysql cli
SQL
1 vote291 views3 answers
Drop unique key constraint in sql server
SQL
0 vote283 views1 answer
Mariadb number format
SQL
0 vote279 views1 answer
View acl table oracle
SQL
2 votes267 views1 answer
Insert from table tsql
SQL
3 votes309 views1 answer
Postgres select max value
SQL
0 vote229 views1 answer
Sqlalchemy existing database
SQL
2 votes313 views2 answers
Spring where to put the data sql
SQL