/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

11 votes339 views3 answers
Change column name sql server management studio
SQL
0 vote379 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote328 views1 answer
How to check xampp mysql password
SQL
1 vote340 views1 answer
Oracle sql pad left zeros
SQL
3 votes342 views2 answers
Create schema postgres
SQL
0 vote341 views1 answer
Create table database in psql
SQL
0 vote328 views1 answer
Oracle create package specification
SQL
1 vote371 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote358 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
12 votes332 views4 answers
Mysql get date difference in hours
SQL

Share