/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 vote229 views1 answer
Alasql delete column
SQL
0 vote259 views1 answer
Insert value in identity
SQL
1 vote225 views1 answer
Oracle convert run duration to number
SQL
0 vote226 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
8 votes232 views1 answer
Oracle add months to sysdate
SQL
10 votes236 views3 answers
Sql check double value
SQL
0 vote221 views1 answer
Sql cross apply vs join
SQL
0 vote225 views1 answer
Sql count null as 0
SQL
0 vote231 views2 answers
Plsql function that return a table
SQL
1 vote226 views1 answer
Update and replace mysql
SQL

Share