Re: tables in sqlplus
From: Matt B. <mcb_at_ds.znet.com>
Date: Mon, 19 Feb 2001 07:48:06 -0800
Message-ID: <t92fr9so8hmt45_at_corp.supernews.com>
Date: Mon, 19 Feb 2001 07:48:06 -0800
Message-ID: <t92fr9so8hmt45_at_corp.supernews.com>
[Quoted] "Rafal Jank" <yankee_at_wp-sa.pl> wrote in message
news:3A913A67.D82BA047_at_wp-sa.pl...
> Maciej Kwapulinski wrote:
> >
> > Hallo
> > Do You how to display all tables that belong to database, using sqlplus
> > tool
> > greetings
> select table_name from user_tables;
> R.
[Quoted] IIRC, not quite.
select table_name from dba_tables;
"user_tables" will give the tables that belong to the user, not all the tables in the database.
-Matt Received on Mon Feb 19 2001 - 16:48:06 CET