Thread: View Tables

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    1
    Rep Power
    0

    View Tables


    I am new to Oracle and SQL and have starting reading up on it. The question I have is there a way to view a list of the tables in Oracle SQLPLUS as in MySQL?

    Thanks!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    11
    Please try:

    select * from user_tables;
    select * from all_tables;
    select * from tab;

    Regards,
    Dan

IMN logo majestic logo threadwatch logo seochat tools logo