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!

Best Regards,
Hogger