/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 vote241 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
8 votes188 views2 answers
Phpmyadmin password
SQL
1 vote204 views1 answer
Postgresql define pk sequence next number
SQL
1 vote193 views1 answer
Oracle get current schema
SQL
1 vote221 views4 answers
Get week day from date in sql
SQL
0 vote315 views1 answer
Add user mysql wordpress
SQL
1 vote294 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
-2 votes285 views1 answer
Mysql not empty
SQL
11 votes304 views1 answer
Oracle insert from select
SQL
1 vote199 views1 answer
Show table columns
SQL

Share