Re: sql select statement

From: Mark Malakanov <markmal_at_home.com>
Date: Sun, 22 Apr 2001 00:27:52 GMT
Message-ID: <cApE6.22070$_P.5628294@news3.rdc1.on.home.com>

All tables wil be lsited with
select table_name from DBA_TABLES;

ALL_TABLES will show tables are accessibe (granted) for user. Or you have to have SELECT ANY TABLE privilege.

--
-----------------------------------------------------
Thanks,
Mark

"Kay Schulz" <kay_schulz_at_yahoo.com> ???????/???????? ? ???????? ?????????:
news:kay_schulz-D78FD4.20291721042001_at_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 - 19:27:52 CDT