Re: Creating user_constraint query with indents

> 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 CST