DEV Community

Casualwriter
Casualwriter

Posted on • Updated on

A simple hta program to document oracle tables

Just code a hta (html application) program to document table/view for oracle. It use Microsoft OLE DB (MSDAORA) to connect to oracle. no more dependence.

https://github.com/casualwriter/hta-db-schema

screen layout of db-schema-oracle

  1. single file without dependence.
  2. document oracle using built-in "comments" feature.
  3. classify tables/views into "folder"
  4. doubleclick to add/modify table description
  5. doubleclick to add/modify column description
  6. show and print table definition
  7. search keyword in name or description

no installation is needed. Just download file db-schema-oracle.hta to local, and click to run.

ps: the code is simple (in 270 line). you may check it out here before run

first screen, input parameter for DB connection

enjoy,

Top comments (0)