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

7 Answers

0 votes
NULL
answered Sep 15, 2015 by SybFantin
0 votes
NULL
answered Sep 15, 2015 by SammieLLEgjp
0 votes
NULL
answered Sep 15, 2015 by NelRobinett
0 votes
NULL
answered Sep 15, 2015 by AnthonyEchol
0 votes
NULL
answered Sep 15, 2015 by DaciaLeverin
0 votes
NULL
answered Sep 15, 2015 by Wil9391
0 votes
NULL
answered Sep 15, 2015 by Natalie13Jos

...