/SQL/Oracle source code

Oracle source code

Oracle source code

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

6

Oracle source code

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

2 votes341 views2 answers
Mysql on duplicate key ignore
SQL
3 votes358 views2 answers
Postgres show table schema
SQL
3 votes355 views1 answer
Pl sql escape &
SQL
0 vote356 views1 answer
How to alter length character varying postgres
SQL
0 vote378 views1 answer
Sql declare variable single line
SQL
0 vote321 views1 answer
Mysql date + 1 day
SQL
0 vote357 views1 answer
Mysql loop through databases and execute query
SQL
7 votes340 views1 answer
Sql management studio display line numbers
SQL
1 vote364 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote349 views1 answer
Sql gap missing values
SQL

Share