hi all,
i've a querry that is to find out
what all columns have constraints applied on them. giving the
table_name,column_name,constraint name and constraint type.
the querry goes like..
select
a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom
user_tables a,user_constraints b,user_cons_columns cwhere
a.table_name=b.table_name
andb.constraint_name=c.constraint_name/
now i need to make a report which
gives out in the same result all the tables' columns which have constraints and
which have not, both.
leaving the constraint_type and
constraint name columns null in the same querry.
is it possible, or do we have other
alternative to do that.
pls suggest.
thanks
saurabh
Received on Fri May 25 2001 - 01:34:27 CDT
