How to find text in oracle stored procedure

USE : user_source table
select * from user_source where type = ‘PROCEDURE’ and lower(text) like lower(‘%text%’);

Related

Related Posts

Oracle DECODE function

abhisanto
December 1, 2012
0

Oracle DECODE function Oracle decode function allow to transform data values at retrieval time. Syntax : DECODE(expr, search, result [, search, result ]… [, default […]

Oracle 9i Tutorial : INSERT Statement Syntax

abhisanto
December 29, 2010
0

INSERT Statement Syntax INSERT statement is used to add new rows to table.Syntax of INSERT statement below : Only one row can be inserted at […]

Oracle 9i Tutorial : CREATE TABLE Syntax

abhisanto
December 26, 2010
0

Oracle 9i Tutorial : CREATE TABLE Syntax •You must have: –CREATE TABLE privilege –A storage area •You specify: –Table name –Column name, column data type, […]

Leave a Reply Cancel reply