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 vote252 views1 answer
Sql get user account
SQL
32 votes277 views6 answers
Sql count where
SQL
0 vote263 views1 answer
Mariadb maximum left join
SQL
3 votes289 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote279 views1 answer
ORA-13717
SQL
0 vote255 views1 answer
Sum value by month sql
SQL
0 vote272 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote269 views1 answer
Get number of rows in every table mysql
SQL
0 vote291 views1 answer
Mysql edit trigger
SQL
1 vote254 views1 answer
How to select random rows from table
SQL