Re: tables in sqlplus
From: Maciej Kwapulinski <pikpok_at_univ.gda.pl>
Date: Tue, 20 Feb 2001 08:22:06 -0500
Message-ID: <3A926F7E.2D35315D_at_univ.gda.pl>
Date: Tue, 20 Feb 2001 08:22:06 -0500
Message-ID: <3A926F7E.2D35315D_at_univ.gda.pl>
"Matt B." wrote:
> "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.
>
> 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
Hallo Matt
Thank You for help
greetings
Maciej
Received on Tue Feb 20 2001 - 14:22:06 CET