Re: how to list all tables in sqlplus
From: Steve <sfang88_at_yahoo.com>
Date: Thu, 23 Nov 2000 12:47:42 -0500
Message-ID: <3A1D583E.ECDB6F05_at_yahoo.com>
Date: Thu, 23 Nov 2000 12:47:42 -0500
Message-ID: <3A1D583E.ECDB6F05_at_yahoo.com>
[Quoted] [Quoted] I tried "select table_name from dba_tables" but it says there is no table [Quoted] "dba_tables". What could other name be? Thanks Matt!
Steve
"Matt B." wrote:
> "Steve" <sfang88_at_yahoo.com> wrote in message
> news:3A1D49E8.9E1324F8_at_yahoo.com...
> > I am using SQL*Plus. Is there anyway to list all the names of tables in
> > the database? It will be nice to know what tables are in the database.
> > Thanks!
> >
> > Steve
>
> select table_name from dba_tables
>
> -Matt
Received on Thu Nov 23 2000 - 18:47:42 CET