Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


how to constrain a database table so only one row can have a particular value in


how to constrain a database table so only one row can have a particular value in  using -'oracle,triggers,constraints'

Using Oracle, if a column value can be 'YES' or 'NO' is it possible to constrain a table so that only one row can have a 'YES' value?

I would rather redesign the table structure but this is not possible.

[UDPATE] Sadly, null values are not allowed in this table.
    

asked Sep 14, 2015 by MadStein
0 votes
4 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...