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 : Naming Rule

Naming Rules : Table names and column names: Must begin with a letter Must be 1–30 characters long Must contain only A–Z, a–z, 0–9, _, […]

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 : ALTER TABLE Statement

 ALTER TABLE Statement          After you create a table, you may need to change the table structure because: you omitted column, your column definition needs […]

Leave a Reply

Discover more from Abhyas

Subscribe now to keep reading and get access to the full archive.

Continue reading