Select from Des. 9i - Views

From: Steff <s.schemel_at_gmx.net>
Date: 20 Nov 2003 01:48:46 -0800
Message-ID: <be02a2ad.0311200148.45d1acd1@posting.google.com>

Hi,

I want to select data from the Designer 9i-Repository-Views...

What I want to get as a result:
Every constraint relating a column. The problem is, that it's not possible to join both views (CI_COLUMNS,CI_CONSTRAINTS) directly. I tried several select-statements, without the expected result... I tried something like this:

[snip]

select td.name, ci.name ,decode(con.constraint_type,'PRIMARY','PK',

	   		 decode(con.constraint_type,'FOREIGN','FK',
			 decode(con.constraint_type,'UNIQUE','UK','')))
from ci_relation_definitions td,
     ci_columns ci,
     ci_constraints con

 where td.name='EXAMPLE'
   and ci.TABLE_REFERENCE = td.ID
   and c on.TABLE_REFERENCE = ci.TABLE_REFERENCE
[snip]

Any help appreciated!

Regards,
Steff Received on Thu Nov 20 2003 - 03:48:46 CST