Oracle limitation

Question

Is it possible to add a validation constraint that ensures that all values ​​are unique, but allow duplicate default values?

Answer 1

You can achieve this using a funcction-based index (FBI):

create unique index idx on my_table (case when col != 'DEFAULT' then col end)); 

This creates a unique index for all values ​​except "DEFAULT".