Re: Viewing tables in database
From: Albert Minich <Albert_77_at_gmx.net>
Date: 27 Aug 2002 06:31:56 GMT
Message-ID: <Xns927756CBF9A4E110oo011_at_139.2.1.5>
Date: 27 Aug 2002 06:31:56 GMT
Message-ID: <Xns927756CBF9A4E110oo011_at_139.2.1.5>
Joseph George meinte:
> Can we view tables in a database from SQLPlus? I am new to Oracle. In
> MySQL you have a command 'Show tables' which lists all the tables in a
> database. Any equivalent command in SQLPlus?
>
> Thanks,
> Joseph
Hi Joseph,
for user tables:
SELECT owner, table_name, tablespace_name FROM sys.all_tables
WHERE owner NOT IN ('SYS','SYSTEM');
for all tables:
SELECT owner, table_name, tablespace_name FROM sys.all_tables;
Albert Received on Tue Aug 27 2002 - 08:31:56 CEST