Wednesday, May 20, 2020

How to export data dictionary with Oracle SQL Developer

Oracle SQL Developer is a free development tool for Oracle database. It has a nice feature of generating data dictionary and exporting it to HTML.

To generate data dictionary create connection to your database, then select connection, right click and choose Generate DB Doc....
Then choose output directory and optionally take time to select database object types.
Click OK and wait for export to complete. This is how it looks:


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

OIC File Handling – Removing .pgp and Preserving .csv (Dynamic File Name Logic) | use of ast-index-within-string() function

📌 Problem Statement In Oracle Integration Cloud (OIC), while working with Stage File, we often receive source files like: a.b.c.csv.pgp 🔐 ...