How does order by row id work in Oracle?
<p>I have a table called points. I executed the following query and expected a list of lexicographicaly sorted list of ROWIDs but that did not happen. How does Order by rowid sorts the row?</p>

<pre><code>select rowid from points order by rowid
</code></pre>

<p>I had rows like following </p>

<ol>
<li>AAAE6MAAFAAABiSAAA</li>
<li>AAAE6MAAFAAABi+AAA</li>
</ol>

<p>2nd row is lexicographicaly smaller than first row. So what is sorting criteria if it is not lecxicographical sorting?</p>