Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to view all tables?

Re: how to view all tables?

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 10 Apr 2005 17:51:40 GMT
Message-ID: <Xns96346E7CD56CSunnySD@68.6.19.6>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US