title: Oracle compare dimensions of a box against a reference
body: <p>I have a table with box dimensions LENGTH, WIDTH and HEIGHT. I want to compare this box with a reference box to see if the box is bigger than the reference box and output for each box, if the box is bigger or not.</p>
  
  <p>Lets say LENGTH, WIDTH and HEIGHT are 4,6 and 2 respectively. And the reference box dimensions are 3,5 and 8. In this case the box is smaller than the reference because (2,4,6) &lt; (3,5,8).</p>
  
  <p>So basically I have to compare the <strong>ordered</strong> box dimensions with the <strong>ordered</strong> given dimensions. Is there a way to do this with oracle?</p>
  
  <p>I have already come across the GREATEST and LEAST functions, but I can't compare the middle dimension using those methods.</p>