Results 1 to 4 of 4

Thread: How to List my tables in Oracle database

  1. #1
    Guest

    Default How to List my tables in Oracle database

    I am glad to know that we have Database forum here.

    Just installed Oracle database server under Ubuntu Linux, It did took some time but finally beast is installed.

    Now how do I list tables? Mysql has
    Code:
    SHOW DATABASES;
    USE mydb;
    SHOW TABLES;
    SELECT * FROM mytable;
    So far I am able to login into the Oracle using command-line tool called SQL*Plus:
    Code:
    $ sqlplus scott/tiger
    Now how do I list tables?

    I am just taking print out of Oracle sql pdf but please give me command so that I know it is working.

  2. #2
    Never say die nixcraft's Avatar
    Join Date
    Jan 2005
    Location
    BIOS
    Posts
    4,512
    Thanks
    17
    Thanked 799 Times in 511 Posts
    Rep Power
    10

    Default

    To list all your tables in Oracle server, use the following command:
    Code:
    SELECT * FROM cat;
    First connect to server using Oracle sql plus client:
    Code:
    sqlplus scott/tiger
    Now type at sql> prompt:
    Code:
    SELECT * FROM cat;
    Also don't forget to set the column widths
    Code:
    COL table_name FORMAT a30;
    COL table_type FORMAT a30;
    Now to get list of tables in oracle:
    Code:
    SELECT * FROM cat;
    All [Solved] threads are closed by mods / admin to avoid spam issues. See Howto mark a thread as [Solved]


  3. #3
    Guest

    Default

    yupeeeeeeeeeee worked like a charm \/

  4. #4
    Is that all you got? rockdalinux's Avatar
    Join Date
    May 2005
    Location
    Planet Vegeta
    Posts
    987
    Thanks
    27
    Thanked 71 Times in 62 Posts
    Rep Power
    20

    Default

    Oracle - i can't touth that :P
    Rocky Jr.
    What's wrong? I hope I am not making you uncomfortable...

    Never send a boy to do a mans job.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Oracle "show databases" list
    By raj in forum Databases servers
    Replies: 2
    Last Post: 15th October 2011, 09:28 AM
  2. Routing tables flushed
    By milank in forum Linux hardware
    Replies: 3
    Last Post: 24th December 2007, 11:51 AM
  3. Routing Tables flushed
    By milank in forum CentOS / RHEL / Fedora
    Replies: 0
    Last Post: 5th November 2007, 11:26 PM
  4. Installing oracle database on debian
    By raj in forum Databases servers
    Replies: 1
    Last Post: 16th August 2007, 07:00 PM
  5. IP Tables Configuration
    By jhn_daz@yahoo.com in forum Networking, Firewalls and Security
    Replies: 2
    Last Post: 23rd July 2007, 03:40 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •