Generate Large Datasets of Oracle Test Data

Full Support for Essential Column Data Types

The tool supports a huge 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

With a rich set of data generation options for each supported data type, you can quickly customize a data generator by changing the basic and custom settings.

• Number of NULL values
• Number of empty values
• Data uniqueness
• Country-specific data
• Value ranges
• Value distribution mode
• Row distribution mode
• Data generation by time and by specified number of rows

Data Integrity Support

The tool supports foreign keys (auto- or manually assigned to the column) to maintain data integrity when populating multiple tables. Disabling triggers and check constraints allows:

• Getting accurate generated data
• Improving performance and data synchronization process
• Saves time and efforts when working with databases and generating data
• Specify application behavior when an error occurs

Domain Integrity Support

Data Generator supports SQL CHECK constraint feature that:

• Helps you easily generate consistent data across a single column or multiple columns of a table
• Assures data integrity
• Improves data accuracy results
• Increase data quality

With the Data Generator tool, disabling check constraints helps you avoid interference with database logic.

Multiple Ways to Populate Data

With the Data Population options, the generated data population script can be managed in the following ways:

• Open the script in the internal editor to add data to the database
• Save the SQL script to a file for the future use
• Run the script against a database

In addition, data population can be customized up to your needs that may include:

• Rollback changes during synchronization
• Disable foreign keys and check constraints in the databases
• Use SQL*plus commands

Basic Generators

The tool offers a collection of 15+ random basic generators to populate tables with various types of values. The list of basic generators includes:

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

Meaningful Generators

dbForge Data Generator for Oracle includes 200+ meaningful predefined generators grouped by specific category. They allow creating Oracle dummy data for the tables you want to populate. The tool can insert data in your tables:

• IDs
• Post codes
• Phone numbers
• Countries
• Credit card numbers
• First and Last Names
• Product categories

User-defined Generators

With the Data Generator options, you can easily create your custom generators that would better satisfy your requirements. The generators can be based on the template or built from the scratch and emulate data in the categories: Business, Health, Location, IT, Payment, Personal, and Product.

Instead of customizing predefined generators over and over again, you can configure settings for your own generators and save them to use whenever you need.

Command-line Interface

Using the command-line interface can drastically save your time and increase efficiency in performing routine data generation tasks.

• Automating data generation
• Maintaining PowerShell compatibility for automatic data generation
• Saving a .bat file with data generation settings for later use
• Formatting the code through the command line