[ILUG] [OT] oracle -> show tables?

Tue Mar 20 14:42:56 GMT 2001

select * from dba_tables;

I Think,
	D.

David Hamilton
Senior Technical Consultant
HP Ireland

Direct Line    +353 (1) 6158320
Fax Number     +353 (1) 6158296
Mobile Phone   +353 (86) 8158320
Email          David_Hamilton at dub.exch.hp.com

This message is confidential and may also be legally  privileged.  If you
are not the intended recipient please notify the sender immediately.  You
must not copy this message or use it for any purpose, nor publish or
disclose its contents to any other person.

-----Original Message-----
From: Paul Jakma [mailto:paulj at itg.ie]
Sent: 20 March 2001 14:40
To: ilug at linux.ie
Subject: [ILUG] [OT] oracle -> show tables?

how do get a list of the table names in oracle? sort of looking for
the sqlplus equivalent of \dt or show tables;.

ta,

--paulj

-- 
Irish Linux Users' Group: ilug at linux.ie
http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information.
List maintainer: listmaster at linux.ie