List default column values for all tables in a database
0
votes
2
answers
659
views
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?
Asked by User1974
(1527 rep)
Mar 28, 2017, 09:22 PM
Last activity: Apr 21, 2017, 05:05 AM
Last activity: Apr 21, 2017, 05:05 AM