Oracle Data Generator

The Data Generator feature of dbForge Studio for Oracle provides a smart and powerful solution for Oracle data generation tasks. Data Generator includes 200+ various generators for essential Oracle data types to populate Oracle tables with most frequently-used data. In addition, dbForge Studio for Oracle allows automating data generation process with the command-line functionality.

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

Wide selection of settings allows customizing data generation exactly the way you need. You can set up:

  • Row distribution mode
  • Number of NULL rows
  • Number of empty rows
  • Data uniqueness
  • Value ranges
  • Value distribution mode
  • Region for country-specific data

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 constraints 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 can be immediately executed against an Oracle database, saved for the future use or edited in the internal editor.

Basic generators

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

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

Meaningful generators

DbForge Studio for Oracle includes 200+ generators, that allow populating Oracle tables with real-world test data. In particular, the 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

You can create, save, and use your own generators that would better meet your needs, instead of customizing existing generators over and over again.

Real-time preview of generated data

A convenient preview pane gives you real-time visualization of the changes you make while you adjust data generation settings. This gives you an opportunity to quickly make visual assessment of the data that will be generated.

Command-line interface

The command-line functionality allows scheduling routine Oracle data generation tasks. In addition, you can create a command line execution file with preset options and parameters for Oracle data generation, and run it with a single click.

Availability in editions of dbForge Studio for Oracle

Feature

Ent

Pro

Std

Exp

Data Generator with 200+ predefined meaningful data generators
Yes
No
No
No