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

0 vote550 views1 answer
Power bi connect to postgresql
SQL
0 vote264 views1 answer
Pl sql round
SQL
1 vote265 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote272 views1 answer
Knex last insert id mysql
SQL
0 vote263 views2 answers
Database owner can't create new tables postgres
SQL
0 vote278 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote271 views1 answer
Cast for print sql
SQL
18 votes249 views4 answers
Foreign key mySql
SQL
12 votes270 views4 answers
Mysql version query
SQL
0 vote255 views1 answer
Zsh: command not found: mysql mamp
SQL