1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

command to show all the tables in oracle

Discussion in 'MySQL' started by alanX, Jan 2, 2007.

0
  1. #1
    Hi all,
    what is the command to show all the tables i created before in oracle.

    thanks
     
    alanX, Jan 2, 2007 IP
  2. The Stealthy One

    The Stealthy One Well-Known Member Affiliate Manager

    Messages:
    3,043
    Likes Received:
    54
    Best Answers:
    0
    Trophy Points:
    105
    #2
    show tables;
     
    The Stealthy One, Jan 3, 2007 IP
  3. alanX

    alanX Peon

    Messages:
    61
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    It seems only to work in MYSQL.
    I try servral time "show tables", but error message appears as follow:
    " SP2-0158: unknown SHOW option "tables"
     
    alanX, Jan 3, 2007 IP
  4. The Stealthy One

    The Stealthy One Well-Known Member Affiliate Manager

    Messages:
    3,043
    Likes Received:
    54
    Best Answers:
    0
    Trophy Points:
    105
    #4
    Hmmm, then try:

    select * from tabs;
     
    The Stealthy One, Jan 4, 2007 IP
  5. dushtmanav

    dushtmanav Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    try select * from cat ;
     
    dushtmanav, Jun 25, 2011 IP
  6. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #6
    A similar thread found via Google.
     
    mwasif, Jun 26, 2011 IP
  7. DString

    DString Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    This is the command to show tables in Oracle database:
    select * from user_objects
    where object_type ='TABLE';

    if you do a desc on the user_objects table you will see the fields (columns) you may want to eliminate to get a cleaner result. see the results below:
    SQL> desc user_objects;
    Name Null? Type
    ----------------------------------------- -------- ----------------

    OBJECT_NAME VARCHAR2(128)
    SUBOBJECT_NAME VARCHAR2(30)
    OBJECT_ID NUMBER
    DATA_OBJECT_ID NUMBER
    OBJECT_TYPE VARCHAR2(19)
    CREATED DATE
    LAST_DDL_TIME DATE
    TIMESTAMP VARCHAR2(19)
    STATUS VARCHAR2(7)
    TEMPORARY VARCHAR2(1)
    GENERATED VARCHAR2(1)
    SECONDARY VARCHAR2(1)
    NAMESPACE NUMBER
    EDITION_NAME VARCHAR2(30)

    SQL>
     
    DString, Jan 12, 2012 IP
  8. TechDone

    TechDone Greenhorn

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #8
    You can use select * from tab to see all tables in oracle, hope it helps you
     
    TechDone, Jan 17, 2012 IP
  9. inayah

    inayah Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    try this


    SELECT * FROM cat;
    COL table_name FORMAT a30; COL table_type FORMAT a30;
    SELECT * FROM cat;
     
    inayah, Feb 3, 2012 IP