I have a table "trial_volts" like this in an oracle database (I think it's 10g):
And I want to get a list of trial_index where more than N voltages are above some threshold. I had hoped there would be some function that would let me do this:
SELECT trial_index, SOME_FUNCTION(voltage_1>10,voltage_2>10,voltage_3>10,voltage_4>10,voltage_5>10) AS vOver FROM trial_volts WHERE vOver>3;
...but there does not seem to be such a function. I know this table design is terrible, but I didn't design it and I can't change it, so I've got to find something that works.