dbForge Data Generator for Oracle

Automatically generate large Oracle table datasets.

Published by Devart
Distributed by ComponentSource since 2005

Prices from: $ 323.35 Version: 6.0.85 Updated: Mar 13, 2025

Screenshot of dbForge Data Generator for Oracle

dbForge Data Generator for Oracle Features

Full support for essential column data types
Column Data Types
Flexible data customization
Data Customization
Data integrity support
Data Integrity
Domain integrity support
Domain Integrity
Multiple ways to populate data
Populate Data
Basic generators
Basic Generators
Meaningful generators
Meaningful Generators
User Defined generators
User Defined
Full support for essential column data types

Full support for essential column data types

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

dbForge Data Generator for Oracle

Click for more<strong>Full support for essential column data types</strong><br /><br />
Flexible data customization

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

dbForge Data Generator for Oracle

Click for more<strong>Flexible data customization</strong><br /><br />
Data integrity support

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.

dbForge Data Generator for Oracle

Click for more<strong>Data integrity support </strong><br /><br />
Domain integrity support

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.

dbForge Data Generator for Oracle

Click for more<strong>Domain integrity support</strong><br /><br />
Multiple ways to populate data

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.

dbForge Data Generator for Oracle

Click for more<strong>Multiple ways to populate data</strong><br /><br />
Basic generators

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

dbForge Data Generator for Oracle

Click for more<strong>Basic generators</strong><br /><br />
Meaningful generators

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 and Last Names
  • Product Categories

dbForge Data Generator for Oracle

Click for more<strong>Meaningful generators</strong><br /><br />
User Defined generators

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.

dbForge Data Generator for Oracle

Click for more<strong>User Defined generators</strong><br /><br />