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

Home -> Community -> Usenet -> c.d.o.tools -> Re: listing all tables in a database??

Re: listing all tables in a database??

From: Johannes Wilhelm <x15_at_aixterm8.urz.uni-heidelberg.de>
Date: 29 Dec 2000 12:52:37 GMT
Message-ID: <92i1el$hpb$1@news.urz.uni-heidelberg.de> 






hawk <hawk_at_hotmail.com> wrote:


> Hi all,

 


> Is there a way to list all the tables in a database.  I use Oracle 7 for

> UNIX.


> Thanks





  with



    select * from all_tables;



 you can see all within your scope



 Johannes
Received on Fri Dec 29 2000 - 06:52:37 CST












Original text of this message













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