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 :: mysql find missing values
Sql :: postgresql today - 1 year
Sql :: oracle plsql sleep
Sql :: ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
Sql :: get top 10 records in oracle
Sql :: where date in datetime mysql
Sql :: table or view does not exist
Sql :: mysql timestamp to date
Sql :: psql connect as user with password
Sql :: sql concat string with column value
Sql :: django mssql backend
Sql :: sql server: difference between hashtable and table declared using declare keyword
Sql :: how to see the query of a view in mysql
Sql :: mysql docker image for macbook m1
Sql :: oracle trigger after logon on schema
Sql :: CX_Oracle - import data from Oracle to Pandas dataframe
Sql :: mysql concatenate null
Sql :: c# sql select
Sql :: convert sql to relational algebra
Sql :: identify number of rows in sql
Sql :: postgresql create query
Sql :: order by desc postgres
Sql :: drop table if exists test
Sql :: create stored procedure
Sql :: mysql show all table from database
Sql :: sql current timestamp table
Sql :: replace null in sql
Sql :: mysql auto increment after delete
Sql :: oracle running queries
Sql :: sql all columns