APRIL 24
Newsgroups: comp.databases.oracle
Subject: Re: This is an easy one ..how do I do a simple directory listing of my
          available Oracle 7 tables
References: <4lkc7s$dod@ionews.ionet.net>

erickson@ionet.net (Roger Erickson) writes:

(How can I do a simple directory listing of my Oracle7 tables....)

>using SQL.  I am ODBC connected and can query any one table.  I just don't know 
>how to create a list of the tables.  I've read all the docs I have and it 
>doesn't flash out at me.  Please help a newbee.

>Thank you

>Roger

Roger,

If you have a dba account, type:

SELECT * FROM DBA_TABLES;

If you have a non-dba account, type:

SELECT * FROM ALL_TABLES;

To limit your selection, use the WHERE clause. For instance, to find all 
tables with the name "PERSON" in it, type:

SELECT * FROM ALL_TABLES WHERE TABLE_NAME LIKE '%PERSON%';

Good luck.
-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: www.arikaplan.com                          <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page tm">Back to Ari Kaplan's Home Page