Re: help me
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 11 May 2001 23:21:19 +0200
Message-ID: <tfolqf6orup2b5_at_beta-news.demon.nl>
Date: Fri, 11 May 2001 23:21:19 +0200
Message-ID: <tfolqf6orup2b5_at_beta-news.demon.nl>
"alfred" <azizp23_at_hotmail.com> wrote in message
news:3AFC3F43.3090409_at_hotmail.com...
> hi team,
> is there any sql instruction to list all my tables or vues stored in the
> database ?
> help me
>
For one time (next time I will refer you to the RTFM command)
select object_name
from user_objects
where object_type in ('TABLE','VIEW');
Hth,
Sybrand Bakker, Oracle DBA Received on Fri May 11 2001 - 23:21:19 CEST