Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle tables referenced by procedures

Status
Not open for further replies.
zephan

zephan

Programmer
Jan 14, 2002
217
A2
Hi All,
How to find for the current user, all the referenced objects (especially tables and mviews) with the referencer if possible (on Oracle 9i 1.0.2).
Regards,
Zephan
 
Sort by date Sort by votes
What do you mean by current user ? Do you mean the user who owns the package or users who are running the package ? For the rest, try SYS.DBA_DEPENDENCIES.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
245
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
282
Andrzejek
Andrzejek
mibeach7
  • Locked
  • Question
Group by challenge 1
Replies
5
Views
204
Andrzejek
Andrzejek
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
207
Olutee360
Olutee360
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
207
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top