DTGen enables developers to rely on this data-driven source code generator to build Oracle data dictionary language (DDL) scripts, as well as Oracle Application Express (APEX) export files.
This development application can dramatically cut down the amount of hours one typically invests in integrating basic functionality to a customized Oracle product.
Here are some key features of "DTGen":
· Data history (audit trails, "undo", archiving, etc...)
· Surrogate keys (very useful, but not intuitive to users)
· Simple domain integrity (ex. "yes" or "no" without foreign key tables)
· Multi-Tier deployment (data caching and integrity at the mid-tier)
· Hierarchical data and paths (ex. manager to employee relationships)
· Data maintenance forms (basic data query and modification)
· Background logging facility (including ease of instrumentation)
Requirements:
· Oracle 11g
What's New in This Release: [ read full changelog ]
New Features:
· Allow %ROWTYPE record for "DML" ins and upd procedures
· Add Custom Copyright Notice to PL/SQL Generated Code
· Add an Option to Constrain Audited Users Against SYS.USR$
· Add Tablespace Storage for Individual Tables
· Add an Update Reserve Percentage for each Column to set PCTFREE
· Cache GLOB Settings at Mid-Tier
· Cache SQL Script Changes in Generate and Only Save Differences
· Read-Only Views Need Trigger Errors
· Specify storage name for (and drop) LOB columns
Closed Issues:
· Defect (Fixed): Foreign Key Prefixes in ACT view join needs to be Unique
· Defect (Fixed): Need more than 100,000 lines in FILE_LINES
· Defect (Fixed): ORU-10027: buffer overflow
· Defect (Fixed): POP INSERT throws no aud_prev_beg_usr data error
· Defect (Fixed): Can't Generate New Files in DTGen GUI
· Defect (Fixed): GUI File Assembly Replaces Files in Other Applications
· Defect (Fixed): Date Format Incorrect on ASOF Reports Menu
· Defect (Fixed): Column Name Too Long Throws UnHandled Exception
· Defec...
Find us on Google+
