Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3676
  • Last Modified:

Oracle view definition

Does oracle store list of tables involved in a view definition? I know that all_views contain select TEXT for views, but I am interested to get only table names. I do not want to parse the TEXT from all_views.
0
sollala
Asked:
sollala
  • 2
1 Solution
 
boriskalavskyCommented:
DBA_DEPENDENCIES
0
 
sollalaAuthor Commented:
This one needs dba access, so I am using user_dependencies
0
 
boriskalavskyCommented:
Why B?
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now