dbForge Data Generator for Oracle is a small but mighty GUI tool for populating Oracle schemas with tons of realistic test data. With extensive collection of basic and meaningful generators for various data types, flexible customization options, templates for creating your own generators, the tool delivers flawless data generation (including random number generation) in a well-designed user interface.

Full support for essential column data types
The tool supports a massive range of column data types, including:

NUMBER
VARCHAR2, NVARCHAR2, CHAR, NCHAR
DATE, TIMESTAMP
INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND
BLOB, CLOB, NCLOB
XMLTYPE

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
Data uniqueness
Value ranges
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 database logic.

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.

Basic generators
With the collection of 15+ basic generators, you can populate tables with various types of values. The tool includes the following generators:

Constant
Files Folder
Foreign Key
Lorem Ipsum
Regular Expression
Shuffled Text
SQL Query
Table or View
Text File
Twaddle
Weighted Lists

Meaningful generators
dbForge Data Generator for Oracle includes 200+ meaningful generators that allow to populate tables with realistic test data. In particular, tool can fill your tables with:

IDs
Post codes
Phone numbers
Countries
Credit card numbers
E-mails
Social Security Numbers
First & Last Names
Product Categories
and much more!

User-defined generators
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.

Command-line interface
With the command-line functionality, you can save time by scheduling routine data generation tasks.



Only for V.I.P