Organizational Research By

Surprising Reserch 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 15, 2015 by TeeGregorio
0 votes
25 views



Related Hot Questions



Government Jobs Opening


...