/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

3 votes124 views1 answer
Créer une table sql
SQL
2 votes137 views2 answers
Mysql add hours to time field
SQL
11 votes131 views4 answers
Update row in mysql
SQL
1 vote109 views1 answer
Tsql random number
SQL
9 votes149 views1 answer
Alter table column change data type to text mysql
SQL
0 vote128 views1 answer
Postgres 11 add primary key
SQL
2 votes131 views1 answer
Oracle to_char number format percentage
SQL
0 vote130 views1 answer
Sqlite3 get data from table c
SQL
1 vote131 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote119 views1 answer
View acl table oracle
SQL

Share