General Notes on Oracle Data Dictionary The Oracle Data Dictionary contains metadata that is readily available via database views.

This personal project is pre-pre-alpha. It's quite fiddly to use and incomplete (not everything you read here exists). Sorry. This PL/SQL package generates database documentation from Oracle data ...

Automatic generation of schema documentation using the Oracle data dictionary tables. > This personal project is pre-pre-alpha. It's quite fiddly to use and incomplete (not everything you read here ...

In this post, I look at some queries I like to use that take advantage of these views from the Oracle Data Dictionary. The ALL_CONSTRAINTS view is great for finding basic constraint details.