Oracle all_source package body

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 vote154 views1 answer
How to run sql script
SQL
16 votes206 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote211 views1 answer
Drush sql-dump
SQL
0 vote188 views1 answer
Suse start MySQL
SQL
0 vote196 views1 answer
How to insert same table data using mysql query
SQL
9 votes208 views1 answer
No sql
SQL
0 vote223 views1 answer
Cube oracle
SQL
0 vote202 views1 answer
Mssql view column data type
SQL
0 vote207 views1 answer
How to check xampp mysql password
SQL
21 votes214 views1 answer
Cheatsheet for sql
SQL