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 using the command line.

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
Supported Data Types

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
Flexible data customization

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.

Data integrity support

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.

Domain integrity support

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.

Multiple ways to populate data

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 Generator
  • Python
  • Regular Expression
  • Shuffled Text
  • SQL Query
  • Table or View
  • Text File
  • Twaddle
  • Weighted Lists
Basic Generators

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!
Meaningful Generators

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.

User-Defined Generators

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.

Real-time preview of generated data

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.

Command-Line Interface

dbForge Studio for Oracle

Multifunctional Oracle GUI

Download

Availability in the editions of dbForge Studio for Oracle

Feature

Enterprise
Professional
Standard
Express
Data Generator with 200+ predefined meaningful data generators
Yes
None
None
None

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.