Re: Creating user_constraint query with indents
From: Andrey A. Efimov <efa_at_leaves.spb.su>
Date: 1997/03/17
Message-ID: <01bc32e4$c649d130$9a2b7dc1_at_efimov>#1/1
Date: 1997/03/17
Message-ID: <01bc32e4$c649d130$9a2b7dc1_at_efimov>#1/1
> I am attempting to create a view of the user_constraints
> table that will show foreign key restraints on tables as
> indented for each table. I have attempted to use the
> connect by clause and keep getting the oracle error:
USER_CONSTRAINTS is a VIEW, it structure you can see in explain plan
select * from USER_CONSTRAINTS, or ALL_VIEWS
it include join
You can't build "connect by" query for join of tables
Received on Mon Mar 17 1997 - 00:00:00 CET