The tool supports a massive range of column data types, including:
VARCHAR2, NVARCHAR2, CHAR, NCHAR
INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND
BLOB, CLOB, NCLOB
Flexible data customization
Data generation options enable you to setup each data generator up to your needs.
You can customize:
Number of NULL values
Number of empty values
Value distribution mode
Data integrity support
The tool supports foreign keys for generation of consistent data across multiple tables.
It also allows disabling triggers and constraints to avoid interference with database logic.
Domain integrity support
Data Generator supports check constraint for generation of consistent data across a single column or
multiple columns of a table. It also allows disabling check constraints to avoid interference with
Multiple ways to populate data
The generated data population script that can immediately be executed against an Oracle database,
saved for future use or edited in the internal editor.
With the collection of 15+ basic generators, you can populate tables with various types of values.
The tool includes the following generators:
Table or View
dbForge Data Generator for Oracle includes 190+ meaningful generators that allow to populate tables with realistic test data. In particular,
tool can fill your tables with:
Credit card numbers
Social Security Numbers
First & Last Names
and much more!
With Data Generator templates, you can create, save, and use your own generators that would better meet your needs,
instead of customizing existing generators over and over again.
With the command-line functionality, you can save time by scheduling routine data generation tasks.