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: Help - really easy question

Re: Help - really easy question

From: TurkBear <johng_at_mm.com>
Date: Fri, 14 Aug 1998 18:05:08 GMT
Message-ID: <35d47be7.755536@news2.mm.com>


Select table_name from all_tables;
or
Select table_name from sys.dba_tables ;

"Judd" <juddt_at_ozemail.com.au> wrote:

>Have now been using Oracle for around 4 hours!
>Have installed PO7
>
>How can I get a listing of tables?
>
>In Centura's SQLBase I can do it with "Select * from systables"
>
>But how do I do this in Oracle?
>What is the equivalent of "Systables"?

To reply please remove the 'nospam' part of the address Received on Fri Aug 14 1998 - 13:05:08 CDT

Original text of this message

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