Re: sql select statement

From: Kay Schulz <kay_schulz_at_yahoo.com>
Date: Sat, 21 Apr 2001 20:29:17 +0200
Message-ID: <kay_schulz-D78FD4.20291721042001@news.t-online.com>

In article <3ae19c90.0_at_news2.tm.net.my>, "M.C.Tan" <tmchun_at_tm.net.my> wrote:

> mousepoet <mousepoet_at_att.net> wrote in message
> news:3AD5415E.2803ACA_at_att.net...
> > What command would I use to list the tables in a database?
> >
>
> Select table_name from user_tables; ========> will list all the
> tables of your database.

All tables wil be lsited with
select table_name from ALL_TABLES;

-- 
Kay Schulz

Received on Sat Apr 21 2001 - 13:29:17 CDT