/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 vote304 views1 answer
Can we rollback deleted data in sql
SQL
1 vote374 views2 answers
Laravel jwt generate token
SQL
2 votes336 views1 answer
Revokeprivileges mysql
SQL
0 vote343 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote311 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote321 views1 answer
Moodle query item quiz
SQL
1 vote316 views1 answer
How to use a trigger to validate input data
SQL
0 vote277 views0 answer
SQL
0 vote312 views1 answer
Sql offfset
SQL
0 vote327 views1 answer
Datagrip execute procedure
SQL