title: Can you SELECT everything, but 1 or 2 fields, without writer's cramp?
body: <p>Is it possible, in PLSQL, to select all of the fields in a table except for 1 or 2, without having to specify the fields you want?</p>
  
  <p>Example, the employee table has the fields:   </p>
  
  <ul>
  <li>id</li>
  <li>firstname</li>
  <li>lastname</li>
  <li>hobbies</li>
  </ul>
  
  <p>Is it still possible to write a query similar to </p>
  
  <pre><code>select * from employee
  </code></pre>
  
  <p>while leaving the field <code>hobbies</code> without with having to write something like this?</p>
  
  <pre><code>select id, firstname, lastname from employee
  </code></pre>