Using Generators

dbForge Studio for Oracle provides a collection of generators to create different column values for the tables you want to populate.

The following basic data generators are available:

  • Check Constraint Generator
  • Constant Generator
  • Datetime Generator
  • Files Folder Generator
  • Foreign Key (auto assigned) Generator
  • Foreign Key (manually assigned) Generator
  • Lorem Ipsum Generator
  • Python Generator
  • Regular Expression Generator
  • Shuffled Text Generator
  • SQL Query Generator
  • String Generator
  • Table or View Generator
  • Text File Generator
  • Twaddle Generator
  • Uniqueidentifier Generator
  • Weighted List Generators

In addition to basic generators, dbForge Studio for Oracle provides 200+ meaningful generators, including advanced generators, and user-defined generators.

To select a generator for a column

  1. In the Tables and columns to populate pane, click a column.
  2. In the Column generation settings pane, select a generator type from the Generator drop-down list box.

    Note

    The Generator list features only those generators that are compatible with data type of the selected column.

  3. (Optional) In the Fill Settings section of the Column generation settings pane, customize the default value generation settings. The array of settings depends on the generator type.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?