how to fetch all relational tables from oracle ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rajeshnaidum
    New Member
    • Nov 2011
    • 1

    how to fetch all relational tables from oracle ?

    hi everybody
    i need to retrive all relational tables from oracle
    can you give me a query for that
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    If you have enough privileges you can you it int the following way
    Code:
    select * from dba_tables

    Comment

    Working...