EMS Data Generator for Oracle is a software tool that helps users generate test data for multiple tables in Oracle databases. With a user-friendly wizard application, it allows the creation of tables for data generation, setting value ranges, and generating character fields and blobs.

Along with the wizard, EMS Data Generator for Oracle also provides a console application that allows you to generate data in one-touch by using generation templates. This feature makes data generation fast and easy, ideal for developers who need to create test data quickly.
The software supports generic Oracle data types, including numeric, character, datetime (DATE, TIMESTAMP), intervals, and binary (RAW, LONG RAW, BLOB) types. It offers different generation types for each field, including list, random, incremental data generation, and more.
EMS Data Generator for Oracle also allows you to use SQL query results as a list of values for data generation. The software ensures automatic control over referential integrity for linked tables data generation, adding to the accuracy of your generated test data.
With a wide variety of generation parameters for each field type, the software lets you set NULL values for certain percent of cases. It saves all generation parameters set on the current wizard session, making it easy to replicate data generation in the future. Moreover, the software provides a command-line utility to generate data using the template file.
Overall, EMS Data Generator for Oracle is an outstanding software utility that streamlines and simplifies the process of generating test data. Its feature-rich operation, combined with ease of use, makes it a great asset for developers who need reliable test data generation to ensure their applications are running smoothly.
Version 3.0:
Unicode support is implemented.
Added new options for data generation to SQL script.
Added options for generating the same data into several columns.
Added options for generating string data according to the sample text.
Data preview is implemented.
Version 2.3:
- Improved data generation for tables with Foreign keys.
- The order the tables are cleared has been corrected according to their dependencies.
- Generation data for arrays (Interbase/Firebird.
- Implemented Private Key support for SSH authentication.
- Other improvements and bugfixes.