Re: How can I show all the tables?

From: <mjain_at_my-dejanews.com>
Date: Wed, 11 Nov 1998 04:25:25 GMT
Message-ID: <72b3jm$q3m$1@nnrp1.dejanews.com>

Following query will list the tables owned by user SCOTT.

Select table_name from dba_tables
where owner = 'SCOTT';

You can use a similar looking query for your user.

Hope this helps,

Manoj Jain

In article <729o0o$15a$1_at_imsp009a.netvigator.com>, "Derek Chu" <hkchu_at_cse.cuhk.edu.hk> wrote:
> Dear all,
>
> Is it possible for me to display all the tables created by a user?
>
> Derek
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 10 1998 - 22:25:25 CST