/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 vote228 views2 answers
Limit sqlserver
SQL
6 votes206 views2 answers
Clear a table in mysql
SQL
5 votes171 views1 answer
Oracle scan source ddl
SQL
2 votes176 views2 answers
Mysql user access to database
SQL
0 vote170 views1 answer
Oracle free up space in tablespace
SQL
-2 votes184 views1 answer
Group functions in sql
SQL
0 vote199 views1 answer
How to create a table in sql stack overflow
SQL
15 votes180 views2 answers
Open postgress in terminal mac
SQL
0 vote178 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote188 views1 answer
Altrer name column postgres
SQL