title: Select columnName,* from table
body: <p>I am a newbie in Oracle SQL, though I have experience in SQL Server.</p>
  
  <p>In SQL Server, to select the rows from a table with a particular column in front:</p>
  
  <pre><code>select columnName,* from tableName
  </code></pre>
  
  <p>In Oracle: </p>
  
  <pre><code>select columnName,* from tableName
  </code></pre>
  
  <p>gives error <strong>ORA-00936: missing expression</strong>, as below:</p>
  
  <p><a href="https://i.stack.imgur.com/d3Xkk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d3Xkk.png" alt="enter image description here"></a></p>
  
  <p>Please guide.</p>