Posted By

geekzspot on 10/12/12


Tagged

Oracle


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

geekzspot
nuukem


Search all PL/SQL


 / Published in: SQL
 

Search all Oracle Database PLSQL Stored Procedures and Functions database code for a string

  1. SELECT * FROM user_source WHERE UPPER(text) LIKE UPPER('%'||'&string'||'%') ORDER BY type, name, line; -- Search all the code

Report this snippet  

You need to login to post a comment.