title: How to SELECT Column, * FROM TABLE in Oracle?
body: <p>I am creating a lot of scripts, and sometimes to check that the tables are being updated as I need, I write on the fly several SELECT statements.</p>
  
  <p>In SQL SERVER you can write something like:</p>
  
  <pre><code>SELECT Column1, *
  FROM MY_TABLE
  </code></pre>
  
  <p>This is useful for visibility reasons, however that doesn't seem to work in ORACLE and I don't know how to achieve it, other than writing down all the Column Names manually.</p>
  
  <p><strong>How can you do this in oracle?</strong></p>
  
  <p>I know we shouldn't include a query like this in our production scripts, etc. I am just trying to use it on the fly while I am running my scripts in development. At different points I'm more interested to see the information of certain columns, in relation to the other ones, but I still want to see all the columns.</p>