title: SELECT * with UNION ALL in Oracle
body: <p>I have a requirement wherein I intend to fetch duplicate records from Oracle DB so as to mimic scenarios wherein we have duplicate records.</p>
  
  <p>So, I decided on using <code>union_all</code>.</p>
  
  <pre><code>select column1 from tbl where rowid in (select rowid from  tbl where rownum&lt;=5)
  union all
  select column1 from tbl where rowid in (select rowid from  tbl where rownum&lt;=5)
  order by column1;
  --works
  </code></pre>
  
  <p>However, when trying to fetch all the columns, </p>
  
  <pre><code>select * from tbl where rowid in (select rowid from  tbl where rownum&lt;=5)
  union all
  select * from tbl where rowid in (select rowid from  tbl where rownum&lt;=5)
  order by column1;
  -- Doesn't work. Invalid identifier
  </code></pre>
  
  <p>Any suggestion on what is wrong here would be great help.</p>