title: Find out the default value for a column (Oracle)
body: <p>I wonder if there is a way to find out the default value of some column with a simple select statement. Tried several things like:</p>
  
  <pre><code>SELECT * FROM all_tab_columns WHERE table_name = 'tablename'
  </code></pre>
  
  <p>But I can't see the defaultvalues for the columns there. And no I do not want to use something like SQL Plus, I need a SELECT, guess there is some table providing that info?</p>