/SQL/Oracle all source

Oracle all source

Oracle all source

select *
from   all_source
where  lower(text) like lower('%Some source%');

6

Oracle all source

SELECT * FROM all_source    -- or user_source or dba_source
WHERE upper(text) LIKE '%MY TEXT%'
ORDER BY owner, name, type, line;

5

Similar codes

22 votes217 views3 answers
SQL CHEATSHEET
SQL
1 vote205 views3 answers
Postgresql connect to database
SQL
1 vote194 views1 answer
Oracle convert run duration to number
SQL
2 votes205 views2 answers
Mysql on duplicate key ignore
SQL
0 vote189 views1 answer
Rollback to name in sql
SQL
0 vote171 views1 answer
Mysql timeout 30 seconds
SQL
16 votes260 views2 answers
Sql vs nosql
SQL
1 vote246 views1 answer
Sql server set variable if exists
SQL
0 vote226 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
1 vote196 views1 answer
Oracle rolling back
SQL

Share