oragen-0.1
Overview
Oragen is a C program that generates random data or unique keys for an Oracle database table based
on how you define the columns in the table It's purpose is for generating dummy data for the use of
testing queries, pl/sql, tuning or for whatever other reason you can think of. Oragen generates
the DML(insert) statement that inserts the data into the table and optionally the DDL(create table)
statement that creates the table before the insert. Only varchar2 and number columns are supported.
The main reason why I wrote this tool is because I needed large tables to test tuning techniques,
effects of indexes, different styles of queries etc, thus oragen.
(working on supporting the date column and a gui frontend -rewriting in java)
download
Examples of Usage