List default column values for all tables in a database I would like to list the default values for all columns in all tables in an Oracle database. The objective is to review the default values, and find any that need updating. 

There are hundreds of tables in the database with columns that have default values, so it would be preferable to do this programmatically, rather than manually.

How can I do this?
Check user_tab_cols(all_tab_cols/dba_tab_cols).  view . DATA_DEFAULT column, as its' name implies, holds default value for the column.