Re: SQL Plus Newbie question

On Fri, 07 Nov 2003 04:02:39 GMT, "Gerald Sylvester" <[EMAIL PROTECTED]>
wrote:

>Is there a command or a way to list the tables in a database?

Fomr an O'Reilly Web page:

SELECT table_name
FROM user_tables;

Note the prefix user_ in this example. Oracle divides data dictionary
views into the three families, as indicated by the following prefixes:
USER_ 

USER views return information about objects owned by the
currently-logged-on database user. For example, a query to USER_TABLES
returns a list of all of the relational tables that you own. 
ALL_ 

ALL views return information about all objects to which you have
access, regardless of who owns them. For example, a query to
ALL_TABLES returns a list not only of all of the relational tables
that you own, but also of all relational tables to which their owners
have specifically granted you access (using the GRANT command). 
DBA_ 

DBA views are generally accessible only to database administrators,
and return information about all objects in the database, regardless
of ownership or access privileges. For example, a query to DBA_TABLES
will return a list of all relational tables in the database, whether
or not you own them or have been granted access to them. Occasionally,
database administrators will grant developers access to DBA views.
Usually, unless you yourself are a DBA, you won't have access to the
DBA views.


--
Richard Steven Hack
"Whatever does not kill me makes me stronger" - 
and YOU have not killed me!