Re: simple question i'm sure, HELP!

Martin Douglas 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.bbnpl
> > 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------------------------------------
To select all application tables from Designer/2000 repsoitory:

		select  tab.name,
		from	
			ci_table_definitions tab,
			ci_application_systems app
		where
			tab.application_system_owned_by = app.id
		and	tab.create_status = 'Y'
		and 	app.version = CURR_APPLICATION_VERSION
		and	app.name    = APPLICATION_NAME
		order by tab.name;

Note:
	Connect as repository owner
	Replace CURR_APPLICATION_VERSION with the version number of your
	application, probably 1.
	Replace APPLICATION_NAME with the name of your application

-- 
- Thor Steinar Tveiten
  Bergen Data Consulting, Norway