Getting Constraint Name from Oracle Database

SELECT   uc.table_name, uc.constraint_name, column_name
    FROM user_cons_columns ucc, user_constraints uc
   WHERE uc.constraint_name = ucc.constraint_name
     AND uc.constraint_type IN ('P', 'U')
ORDER BY 1, 2;