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 Mike Lewis 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
0
0
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
133
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
150
Andrzejek
Andrzejek
mibeach7
  • Locked
  • Question
Group by challenge 1
Replies
5
Views
120
Andrzejek
Andrzejek
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
119
Olutee360
Olutee360
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
119
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top