Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to view all tables?
"Ian" <not_at_available.com.au> wrote in
news:425963b4$1_1_at_news.chariot.net.au:
> Hi,
> I have just installed Oracle 10 on Solaris and would like to practice
> some SQL
> I selected the examples & schema examples to be installed.
> Could someone please help me how to find the examples schema, or the
> command to view all the table names?
> I need to know what to querry. eg select * from ???
> thanking you in advance
>
>
>
SELECT TABLE_NAME FROM {DBA|ALL|USER}_TABLES; SELECT USERNAME FROM DBA_USERS; Received on Sun Apr 10 2005 - 12:51:40 CDT