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

103 votes370 views1 answer
Like sql
SQL
3 votes230 views1 answer
Query less than datetime sql
SQL
0 vote237 views1 answer
Create a sql server database programmatically
SQL
0 vote220 views1 answer
Sqlite referential integrity
SQL
0 vote247 views2 answers
Disallowed function mysql to_date()
SQL
0 vote243 views2 answers
Connect to mysql server mac terminal
SQL
5 votes244 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes242 views2 answers
Storing timezones in postgres
SQL
4 votes238 views2 answers
Oracle last day of month
SQL
0 vote255 views2 answers
How to install psql in ubuntu
SQL