nixCraft

#1 (**permalink**) 12-19-2006, 01:55 AM

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.

nixcraft · #2 (**permalink**) 12-19-2006, 02:03 AM

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;

#3 (**permalink**) 12-19-2006, 02:18 AM

yupeeeeeeeeeee worked like a charm \

/

rockdalinux · #4 (**permalink**) 12-20-2006, 03:25 PM

Oracle - i can't touth that :P

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Routing tables flushed	milank	Linux hardware	3	12-24-2007 11:51 AM
Routing Tables flushed	milank	CentOS / RHEL / Fedora	0	11-05-2007 11:26 PM
Installing oracle database on debian	raj	Databases servers	1	08-16-2007 07:00 PM
IP Tables Configuration	jhn_daz@yahoo.com	Networking, Firewalls and Security	2	07-23-2007 03:40 AM
Oracle "show databases" list	raj	Databases servers	1	05-18-2007 01:21 AM

nixCraft

How to List my tables in Oracle database

How to List my tables in Oracle database

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads