Sure, there are many tools out there which will automatically build a data dictionary for you from an existing schema. Some of those tools include Visual Studio, Toad, Oracle SQL Developer, etc.

-- metadata so that you can copy-paste or export to Excel as a Data Dictionary. CASE WHEN tut.data_type IN('varchar','char') THEN CONCAT('(', CAST(tut.CHARACTER ...

A data dictionary is a document or a tool that describes the structure, meaning, and usage of the data elements in a database. It can include information such as data names, types, sizes ...

The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.