multiple table seen

select utc.table_name, utc.column_name, utc.data_type, utc.data_length,utc.nullable,utc.data_default,

uc.constraint_type, uc.constraint_name

from dba_TAB_COLS utc,  dba_constraints uc where utc.table_name=uc.table_name and uc.constraint_type in ('P','U') 

order by table_name;

is the above SQL is correct? I seen some table name repetation. as I need basic information about table and its column and constraints and datatype.