Re: SQL Plus Question

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Thu, 04 Jan 2001 14:10:00 -0500
Message-ID: <3A54CA88.6CE885DB@Unforgetable.com>

Mark Riehl wrote:
>
> All,
>
> Easy question. What SQL Plus command can I use to show me all of the tables
> in a database? I'm looking for the Oracle equivalent of relshow in MySQL or
> mSQL.
>
> Thanks,
> Mark

Assuming you are logged in with dba priviledges:

select owner||'.'||table_name
from dba_tables
order by 1;

It isn't a sqlplus command though - sqlplus itself has no awareness of the database. It is just a client application that passes dml,dcl, ddl, etc and formats the output. Received on Thu Jan 04 2001 - 13:10:00 CST