Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle search code in packages

SELECT * FROM all_source    -- or user_source or dba_source
WHERE upper(text) LIKE '%MY TEXT%'
	AND TYPE IN ('FUNCTION','PROCEDURE','PACKAGE')
ORDER BY owner, name, type, line;
Comment

PREVIOUS NEXT
Code Example
Sql :: raise application error in oracle 
Sql :: mysql show table character set 
Sql :: create table oracle 
Sql :: sql concate two columns first and last 
Sql :: how to unlock table in mysql 
Sql :: get size of indexes postgres 
Sql :: postgres get month name from date 
Sql :: dump mysql 
Sql :: The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue. 
Sql :: list mysql users 
Sql :: revokeprivileges mysql 
Sql :: mysql list users on ubuntu 
Sql :: mysql server start 
Sql :: name of today sql 
Sql :: oracle compile whole schema 
Sql :: sqlserver add column to table 
Sql :: second last highest id in sql 
Sql :: mysql select greater than yesterday 
Sql :: how to alter table name in mysql 
Sql :: mysql show column data types 
Sql :: mysql create database charset utf8mb4 
Sql :: tsql try catch 
Sql :: snowflake alter column data type 
Sql :: mysql on terminal mac 
Sql :: copy sql table 
Sql :: mysql f# examples 
Sql :: oracle plan hash value 
Sql :: get parameter value in mysql trigger 
Sql :: convert series number to date in sql 
Sql :: add created and updatedAt fields in mysql 
ADD CONTENT
Topic
Content
Source link
Name
1+8 =