Solved

searching package bodies for pl/sql statement

Posted on 2013-01-25
2
524 Views
Last Modified: 2013-01-25
Is there a way to search all package bodies for a pl/sql statement?  Such as "insert into tablename"
0
Comment
Question by:Michael
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
Eikroman earned 500 total points
ID: 38818227
Hello,

select * from DBA_SOURCE where type='PACKAGE BODY' and upper(TEXT) like '%INSERT INTO TABLENAME%'; -- as SYSDBA for all packages in db
select * from ALL_SOURCE where type='PACKAGE BODY' and upper(TEXT) like '%INSERT INTO TABLENAME%'; -- as any user for all accessible packages
select * from USER_SOURCE where type='PACKAGE BODY' and upper(TEXT) like '%INSERT INTO TABLENAME%'; -- as any user for own packages

Open in new window


Update: small correction. ALL_SOURCE - for all accessible packages, and USER_SOURCE for own.
0
 

Author Closing Comment

by:Michael
ID: 38818674
Thanks, have a good day!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question