Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select from Des. 9i - Views
Steff wrote:
> 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
IIRC, in the doc subdir, there's an application dump you can load into designer, which contains an ERD of Designer itself. Have used it in the V2-times, cannot comment, or test on V9
-- Regards, Frank van BortelReceived on Thu Nov 20 2003 - 15:34:18 CST