Re: Newbie Question:How Do I Query What Tables Are In My DB
From: Tariq <taariqq_at_yahoo.com>
Date: Tue, 22 Apr 2003 19:14:32 -0400
Message-ID: <b84ibd0tp2_at_enews4.newsguy.com>
Date: Tue, 22 Apr 2003 19:14:32 -0400
Message-ID: <b84ibd0tp2_at_enews4.newsguy.com>
How about something simpler ?
select * from tab;
"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
news:92eeeff0.0304211929.31d68dfb_at_posting.google.com...
> <clintonvaugh_at_comcast.net> wrote in message
news:<-_ecnV7kdOVJwTmjXTWcqg_at_comcast.com>...
> > All,
> >
> > I'm a newbie at Oracle -- but I wanted to know how can I determine what
are
> > the tables in my DB that was setup during the installation? Also, I'm
using
> > Oracle 9i for Linux.
> >
> > cheers,
>
>
> select object_name
> from user_objects
> where object_type = 'TABLE';
>
> Regards
> /Rauf Sarwar
Received on Wed Apr 23 2003 - 01:14:32 CEST