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 Posts

Oracle 9i Tutorial : INSERT Statement Syntax

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 : Table and Data Dictionary

User Tables: –Are a collection of tables created and maintained by the user –Contain user information Data Dictionary: –Is a collection of tables created and […]

Oracle 9i Tutorial – Database Objects

Database Objects An Oracle database can contain multiple data structures. Each structure should be outlined in the database design so that it can be created […]

Leave a Reply