title: How to resolve 'ambiguous column naming in select list' when 'select col, t.*' is used with an order by clause
body: <p>This is related to:
  <a href="https://stackoverflow.com/questions/2315295/why-is-selecting-specified-columns-and-all-wrong-in-oracle-sql">Why is selecting specified columns, and all, wrong in Oracle SQL?</a></p>
  
  <p>The query:</p>
  
  <pre><code>select is_parent, animals.* from animals order by is_parent
  </code></pre>
  
  <p>throws the error:</p>
  
  <pre><code>[Error] ORA-00960: ambiguous column naming in select list
  </code></pre>
  
  <p>Which makes sense as <code>is_parent</code> is duplicated.</p>
  
  <p>Can anyone tell me a simple fix for this, as the original query <code>select is_parent, animals.* from animals</code> is very nice and quick to return all other columns. I looked at this <a href="http://www.techonthenet.com/oracle/errors/ora00960.php" rel="nofollow noreferrer">link</a> but the technique to remove the ambiguity does not seem to apply. </p>