Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Question on tables
Mike schrieb:
>
> 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
Select * from user_tables;
HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE
Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm
Received on Wed Dec 23 1998 - 00:57:03 CST