Sql

SELECT * FROM all_source    -- or user_source or dba_source
WHERE upper(text) LIKE '%MY TEXT%'
ORDER BY owner, name, type, line;

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

PREVIOUS	NEXT

Code Example
Sql :: postgresql left join distinct on
Sql :: mysql delete user if exists
Sql :: mysql create database with collation
Sql :: clear query cache sql server
Sql :: sql delete caracter list
Sql :: check if table exists oracle
Sql :: pandas to sql index
Sql :: postgresql search object in array
Sql :: mysql columns values as comma separated string
Sql :: add computed column to table sql server
Sql :: select top 10 rows in sql
Sql :: oracle show index columns
Sql :: round one decimal place mysql
Sql :: flask sqlalchemy filter multiple conditions
Sql :: oracle trigger
Sql :: sql substring before last occurrence of character
Sql :: mysql add text to existing field
Sql :: sqlite woth cmake
Sql :: trouver doublons sql
Sql :: is not numeric sql
Sql :: how to truncate table with foreign key constraint postgresql
Sql :: get date from timestamp oracle
Sql :: oracle create table if not exists
Sql :: mysql check datetime equals date
Sql :: username sql
Sql :: how to show index type in postgresql
Sql :: sql server select first day of previous year
Sql :: modify column name in sql
Sql :: oracle get running queries
Sql :: laravel general error 2006 mysql server has gone away