Re: sql statement to show all tables

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sun, 29 Jul 2001 05:56:37 GMT
Message-ID: <pAN87.415396$p33.8425710@news1.sttls1.wa.home.com>

select * from xxx_tables;
where xxx is dba or all or user
user means this user's tables
all means all tables the user can see
dba means all tables
Jim

"Mark Rutherford" <par4kid_at_midsouth.rr.com> wrote in message news:msL87.9021$5w4.681483_at_typhoon.midsouth.rr.com...
> What is the sql statement in oracle 8i to show all tables. I am used to
> using sql server 6.5 and I could run sp_tables and it would list all the
> tables. Is there a similar statement in oracle.
>
> Thanks
>
>
Received on Sun Jul 29 2001 - 00:56:37 CDT