/SQL/Oracle saurce code

Oracle saurce code

Oracle saurce code

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

6

Oracle saurce 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

3 votes264 views2 answers
How to View column names of a table in SQL
SQL
0 vote279 views1 answer
Sqlplus change user
SQL
2 votes299 views5 answers
Install postgresql 10 centos 7
SQL
0 vote297 views1 answer
Sql gather statistics to increase performance
SQL
0 vote288 views5 answers
Select concat alter table mysql
SQL
0 vote291 views1 answer
Raiserror with nowait
SQL
6 votes298 views3 answers
Mysql create database utf8
SQL
0 vote286 views1 answer
Mysql error 1452
SQL
0 vote274 views1 answer
Check sql database table lock
SQL
17 votes276 views6 answers
Get last record in sql
SQL

Share