<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I need to get the minimum value across 4 columns for each row in a table. Pseudocode is like: &nbsp;<br />
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_forea<wbr />chrow<br />
<br />
Is this possible with some sort of arithmetic function or something?
</div>
</div>


Hi:

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?

minium over 4 numeric columns for each row in oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.