/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

0 vote99 views1 answer
Name '_mysql' is not defined
SQL
8 votes103 views1 answer
How to remove tables from postgresql
SQL
0 vote115 views1 answer
How to export only procedures mysql
SQL
10 votes126 views4 answers
Join multiple tables in sql
SQL
0 vote114 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
2 votes117 views1 answer
How to delete all duplicate items in mysql
SQL
40 votes184 views4 answers
PostgreSQL add column
SQL
0 vote112 views1 answer
Mysql_num_fields in mysqli
SQL
8 votes123 views3 answers
SQL column name
SQL
0 vote108 views1 answer
Pagination with row_number
SQL

Share