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:

SELECT * FROM all_tab_columns WHERE table_name = 'tablename'

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?

sql oracle-database select default
Edit
Report