Documentation

oddgen Java Interface

Interface reference documentation to include Client Generators in SQL Developer.

oddgen PL/SQL Interface

Interface reference documentation to include Server Database Generators in SQL Developer.

Tutorial 1

Minimal 1:1 view generator using the mandatory generate function of the oddgen PL/SQL interface only.

Tutorial 2

Extended 1:1 view generator using most optional functions defined in the oddgen PL/SQL interface.

Tutorial 3

Extended 1:1 view generator as client generator variant implementing the oddgen Java interface.

Provided Generator Examples

Xtend

Client generator examples written in Xtend. These client generators are installed with oddgen for SQL Developer.

PL/SQL

Plain PL/SQL examples without using a template engine. Tutorials are based on these examples.

FTLDB

Examples using a FTLDB template. Templates are stored in a conditional PL/SQL blocks ($IF FALSE $THEN … $END).

tePLSQL

Examples using a tePLSQL template. Templates are stored in tables, CLOB variables or conditional PL/SQL blocks ($if false $then … $end).

Demos & Tutorials

Examples, installation scripts, demos, snippets and tutorials.

Template Engines for oddgen Database Server Generators

ftldb_128

FTLDB

Run Apache Freemaker within an Oracle Database Server and write your templates in an extended FTL version called FTLDB.

tePLSQL

tePLQL is a template engine written in PL/SQL. The grammar is based on PL/SQL Server Pages (PSP).