Thread: 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.

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;

yupeeeeeeeeeee worked like a charm \/

Oracle - i can't touth that :P