Universal database documentation generator.

Database documentation generator (DbDoc) creates javadoc-style HTML documentation for database schema objects or/and user defined objects.

For more details and code, see DbDoc project page.

Table API Generator for Oracle

Idea is to only maintain tables and generate table API (TAPI) packages for data manipulation.
Generated:

• insert, update, delete, querying procedures
• documentation based on table columns comments

For example, to insert some data to table, should be used code below

DECLARE
  user_rec ap_users_ta.user_rec;
  user_tab ap_users_ta.user_tab;
BEGIN
  user_rec.id           := 1;
  user_rec.firstname    := 'FirstName';
  user_rec.lastname     := 'LastName';
  user_rec.country      := 'country';
  user_rec.create_date  := SYSDATE;
  user_tab(1) := user_rec;
  ap_users_ta.ins(user_tab);
END;

Example of selecting data:

SET serveroutput ON
DECLARE
  user_rec ap_users_ta.user_rec;
  user_cur ap_users_ta.user_cur;
BEGIN
  user_rec.firstname := 'First%';
  ap_users_ta.qry( user_cur, user_rec );
  FETCH user_cur INTO user_rec;
  CLOSE user_cur;
  dbms_output.put_line( user_rec.firstname || ', ' || user_rec.lastname );
END;

For more details and code, see Table API Generator project page.