Re: simple question i'm sure, HELP!

Martin Douglas <dafis_at_ppp.test.jccbi.gov> wrote:

>In article <Pine.OSF.3.95.961123151900.28095C-100000_at_brain.uccs.edu>, <kdblakel_at_mail.uccs.edu> writes:
>> Path: news.ou.edu!news.nodak.edu!netnews1.nwnet.net!netnews.nwnet.net!arclight.uoregon.edu!feed1.news.erols.com!tezcat!news.bbnplanet.com!cam-news-hub1.bbnplanet.com!uunet!in3.uu.net!csnews!boulder!brain.uccs.edu!kdblakel
>> From: KEVIN!!! <kdblakel_at_mail.uccs.edu>
>> Newsgroups: comp.databases.oracle
>> Subject: simple question i'm sure, HELP!
>> Date: Sat, 23 Nov 1996 15:20:31 -0700
>> Organization: University of Colorado at Boulder
>> Lines: 15
>> Message-ID: <Pine.OSF.3.95.961123151900.28095C-100000_at_brain.uccs.edu>
>> NNTP-Posting-Host: brain.uccs.edu
>> Mime-Version: 1.0
>> Content-Type: TEXT/PLAIN; charset=US-ASCII
>> X-Sender: kdblakel_at_brain.uccs.edu
>>
>> Ok, I am new to this database world and this is actually for a class
>> project. We are using Desinger 2000 and Oracle 7 at school and I would
>> just like to know how through SQL Plus you can get a list of tables within
>> your repository? Any help would be great.....
>>
>> Thanks
>> Kevin
>>
>>
>>
>>
>>
>>
>>
>>
>>
>Select table_name from all_tables;

>or add a where clause like
 

>where owner = 'WhoEverCreatedYourTables';
 

>Martin Douglas

KEVIN,   I think what you really need is to look at CI_TABLE_DEFINITIONS. If you look in the DESIGNER/2000 help under the API help, there is an entire list of all the views associated with the repository. They also include an exam[le of an API program. I believe the select would be something like this:

SELECT tbl.name
FROM ci_table_definitions tbl, ci_application_systems app WHERE app.name = '&my_app'
AND tbl.owned_by_application = app.id
ORDER BY tbl.name;

I believe this is close anyway...you may also want to use CI_CLOUMNS and CI_CONSTRAINTS.

Chet West
TACTICS Inc. (www.tacticsus.com)
cwest_at_tacticsus.com Received on Tue Nov 26 1996 - 00:00:00 CET