ORACLE SQL

alter table componentresource add PRIMARY KEY (COMPONENT_ID, LANGUAGE_ID);


------find duplicate records
SELECT COMPONENT_ID, LANGUAGE_ID FROM componentresource t
GROUP BY COMPONENT_ID, LANGUAGE_ID
HAVING COUNT(*) > 1