Re: Newbie Question:How Do I Query What Tables Are In My DB

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 21 Apr 2003 20:29:02 -0700
Message-ID: <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 Tue Apr 22 2003 - 05:29:02 CEST

Original text of this message