title: SQL (ORACLE): ORDER BY and LIMIT
body: <p>I want do sorting by property ALL data in my db and ONLY AFTER that use LIMIT and OFFSET.</p>
  
  <p>Query like this:</p>
  
  <pre><code>SELECT select_list
      FROM table_expression
      [ ORDER BY ... ]
      [ LIMIT { number | ALL } ] [ OFFSET number ] 
  </code></pre>
  
  <p>I know the sorting ends as soon as it has found the first row_count rows of the sorted result. Can I do sorting all data before calling LIMIT and OFFSET?</p>