View Single Post

  #1 (permalink)  
Old 12-19-2006, 02:55 AM
Guest
 
Posts: n/a
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.
Reply With Quote