/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

1 vote294 views3 answers
Showing all columns in an sqlite table
SQL
-1 vote256 views1 answer
How to format tables in sqlplus
SQL
0 vote358 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
3 votes284 views3 answers
Update join
SQL
3 votes289 views1 answer
Postgresql db owner change
SQL
0 vote309 views1 answer
Trigger vérifier stock
SQL
0 vote333 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
17 votes328 views2 answers
T_sql contains
SQL
1 vote258 views3 answers
Remove unique key from a table
SQL
0 vote283 views1 answer
Postgresql import a database of gzip
SQL

Share