Unique Index

Create Case-Insensitive Unique Index in Oracle

by Ed Chen
April 29, 2022May 27, 2023

Case Insensitive Index Using unique case-insensitive constraint in a column sometimes is reasonable in business logic to prevent duplicate items. Let's see a table that… Read More »

How to Resolve ORA-00001: unique constraint violated

by Ed Chen
May 2, 2020June 6, 2023
8 Comments

ORA-00001 There're only two types of DML statement, INSERT and UPDATE, may throw the error, ORA-00001: unique constraint violated. ORA-00001 means that there's a constraint… Read More »

How to Resolve ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

by Ed Chen
December 28, 2019December 10, 2022

ORA-01452 ORA-01452 means that the unique index that you want to impose on columns cannot be created because of duplicate keys have been found. In… Read More »

JavaScript is not enabled. Please enable it and reload the page.