title: Can i select all columns except a specific column?
body: <p><strong>test_table</strong>:</p>
  
  <pre><code>id   f_name     l_name  age  
  --  --------- --------   ------ 
  </code></pre>
  
  <p>I am new to oracle, but if I want to select all the columns I should use</p>
  
  <pre><code>select * from test_table
  </code></pre>
  
  <p>however if I want to select all the columns except age I should write</p>
  
  <pre><code>select id, f_name, l_name from test_table
  </code></pre>
  
  <p>Is there a way I can select all the columns but disgarding a column or two?</p>
  
  <p>Because in my work busninse there alot of columns and sometimes I don't need to select them all.</p>