SQL Find rows that violate UNIQUE together index

Created Aug 20, 2012 Edited Aug 20, 2012

Viewed 1111

i want to put unique index on two (or more) columns in a table, but i get "duplicate keys found". How to select those rows which cause duplication?

oracle11g sql