title: Oracle SQL: Is ORDER BY non unique field deterministic?
body: <p>Let's say I have a view <code>MYVIEW</code></p>
  
  <pre><code>COL1[CARCHAR2]    SORTINGCOL[NUMBER]
  "itm1"            100
  "itm2"            101
  "itm3"            100
  </code></pre>
  
  <p>and I query the following statement</p>
  
  <pre><code>SELECT *
  FROM MYVIEW
  ORDER BY SORTINGCOL;
  </code></pre>
  
  <p>Is it <strong>guaranteed</strong> (=can I rely on) that the returned order is always the same? let's say </p>
  
  <ol>
  <li><code>item1</code> (with a value of 100) </li>
  <li><code>item3</code> (with a value of 100) </li>
  <li><code>item2</code> (with a value of 101) </li>
  </ol>
  
  <p>It's clear that <code>item2</code> will always end up being the last, but what about <code>item1</code> and <code>item3</code> with the same <code>SORTINGCOL</code> value?</p>