Menu
Can I add a check constraint which makes sure that all values are unique, but allow duplicates of a default value?
931
The three primary constraints that project managers should be familiar with are time, scope, and cost. These are frequently known as the triple constraints or the project management triangle.
Oracle Database lets you create six types of constraints and lets you declare them in two ways. The six types of integrity constraint are described briefly here and more fully in "Semantics ": A NOT NULL constraint prohibits a database value from being null.
You can achieve this using a funcction-based index (FBI):
create unique index idx on my_table (case when col != 'DEFAULT' then col end));
That creates a unique index on all values except 'DEFAULT'.
58
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
