minium over 4 numeric columns for each row in oracle
I need to get the minimum value across 4 columns for each row in a table. Pseudocode is like:
minimum (nvl(t.rating_A,0), nvl(t.rating_B,0), nvl(t.rating_C,0), nvl(t.rating_D,0)) as min_rating_over4cols_foreachrow
Is this possible with some sort of arithmetic function or something?