Re: Newbie Question on tables

There are actually three different views, depending on exactly what you are looking for. SELECT * FROM USER_TABLES will list all the tables owned by the current user. SELECT * FROM ALL_TABLES will list all tables which the current user has rights to. This would include all tables that the user owns and any that the user has been granted access to see. SELECT * FROM SYS.DBA_TABLES will list all the tables in the database. This can only be executed by a user with DBA privileges or a user who has been granted SELECT on the sys.dba_tables view.

Dave

Mike wrote:

> I signing up for classes as we speak!!
>
> I have Oracle 8 on Solaris. From Server Manager or SQL Plus what would
> be a command to list the tables. Or any other suggestions on how to
> accomplish this.
>
> For instance I connect as "Scott Tiger" to the demo database. How
> could I list the tables in this database? From the Oracle Documentation
> I know of one table "emp". How can I find out about the other tables?
>
> Forgive it this question is common knowlegde!!
>
> Thanks in advance
> mike
Received on Wed Dec 23 1998 - 07:21:32 CST