Stored Proc related queries

Show all Oracle  tables inside a stored procedure

select
   referenced_owner,
   referenced_name,
   referenced_type
from
   dba_dependencies
where
   name= 'ADD_ANSWER'
and
   owner = 'HT4'
and
   referenced_type = 'TABLE'
order by
   referenced_owner, referenced_name, referenced_type;
Posted by ViSO at 9/12/2011 9:40 AM
Categories: uncategorized

Previous Post
Next Post

 

What did you think of this article?




Trackbacks
Trackback specific URL for this post
  • Trackbacks are closed for this post.
Comments
  • No comments exist for this post.
Leave a comment

Comments are closed.