Re: sql statement to show all tables

From: Vladimir Ivanovich <vladimiri_at_bosmedtech.com>
Date: Mon, 30 Jul 2001 17:52:23 -0400
Message-ID: <sGk97.1$LK.1888@news.nyc.globix.net>

Mark:

Use views dba_tables and user_tables.

select owner, table_name
from dba_tables
where owner = 'SCOTT';

OWNER                          TABLE_NAME
------------------------------ ------------------------------
SCOTT                          ACCOUNT
SCOTT                          BONUS
SCOTT                          DEPT
SCOTT                          EMP
SCOTT                          RECEIPT
SCOTT                          SALES_EMP
SCOTT                          SALGRADE
SCOTT                          TBL
SCOTT                          WEEKREPORT

9 rows selected.

HTH, Vladimir

"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 Mon Jul 30 2001 - 16:52:23 CDT