EMS Data Generator for Oracle is an impressive utility for generating test data to several Oracle database tables at once.

The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way.

EMS Data Generator for Oracle also offers you a console application, that allows you to generate data in one-touch by using generation templates.

Here are some key features of "EMS Data Generator for Oracle":

· User-friendly wizard interface
· Generating data to several tables from different schemas of database
· Different generation types for each field including list, random, incremental data generation and more
· Ability to use SQL query results as list of values for data generation
· Automatic control over referential integrity for linked tables data generation
· Wide variety of generation parameters for each field type
· Ability to set NULL values for certain percent of cases
· Saving all generation parameters set on current wizard session
· Command-line utility to generate data using the template file
· Support for generic Oracle data types including numeric, character, datetime (DATE, TIMESTAMP), intervals and binary (RAW, LONG RAW, BLOB) types


Requirements:

· 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
· 64 MB RAM (128 MB or above is recommended)
· 20MB of available HD space for program installation
· Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
· Microsoft Mouse or compatible pointing device
· Oracle Client 8.1.7 or higher
· Possibility to connect to any local or remote Oracle server


Limitations:

· 30-day trial
· Generates 100 records at a time