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: 301
  • Last Modified:

views

Is there any way to see all views in oracle database.
Is there any possibility to see exactly queries I mean how that view is created..
0
nobleit
Asked:
nobleit
  • 2
  • 2
1 Solution
 
MrNedCommented:
List of views and their text:

select * from dba_views;
0
 
nobleitAuthor Commented:
Thank you..Is there any way the query behind each one..
0
 
MrNedCommented:
It's there too, in the TEXT column.
0
 
nobleitAuthor Commented:
Helpful..
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

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