title: Displaying RowID in Select * (all) Statement
body: <p>I am trying to display the RowID alongside all columns from a Select * statement.</p>
  
  <p>I am using Oracle with Toad to run the SQL statement.</p>
  
  <p>I have two tables that I need to compare, but I do not have any unique identifiers to use when sorting the two tables for comparison. So I thought that using the RowID to sort the two tables in order to compare them could help.</p>
  
  <p>Is there a way to add RowID to a Select * statement? I cannot add all the columns names as there are over 50 of them. I will be doing this to multiple sets of tables where the number and name of columns will vary.</p>
  
  <p>Any help or ideas around this would be greatly appreciated.</p>
  
  <p>Thanks in advance,</p>
  
  <p>Marwan</p>