DUP_VAL_ON_INDEX Exception in PL/SQL

DUP_VAL_ON_INDEX is a pre-defined exception in PL/SQL which is raised when a program attempts to store duplicate values in a database column that is constrained by a unique index. The name itself explains what this exception is all about. Duplicate Value on Index column Let’s reproduce DUP_VAL_ON_INDEX Create a table named students with columns id(primary key), …

DUP_VAL_ON_INDEX Exception in PL/SQL Read More »