Exforsys
+ Reply to Thread
Results 1 to 2 of 2

how i know the all table names

This is a discussion on how i know the all table names within the Oracle Database forums, part of the Database category; how can i know the all tables names in oracle that are currently using. Also is there is any command ...

  1. #1
    payan is offline Junior Member Array
    Join Date
    Jun 2008
    Location
    pakistan
    Answers
    1

    how i know the all table names

    how can i know the all tables names in oracle that are currently using. Also is there is any command from which i know which table is mostly used


  2. #2
    Gdaniel is offline Junior Member Array
    Join Date
    Jul 2008
    Answers
    2
    You can get current using table names by
    SELECT * FROM USER_TABLES;

    If you want to see all user tables
    SELECT * FROM ALL_TABLES;


Latest Article

Network Security Risk Assessment and Measurement

Read More...