QUERRY DOUBT..

[Saurabh Sharma]

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_name from user_tables a,user_constraints b,user_cons_columns c where a.table_name=b.table_name and b.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