We are pleased to announce the new version of EMS Data Generator - an excellent tool for generating test data to database tables. You can download EMS Data Generator for Oracle from the following link: http://www.sqlmanager.net/products/oracle/datagenerator/download Product Key Features Unicode support User-friendly wizard interface Ability to save and edit generated data in the SQL script without executing queries on the server Support of basic Oracle data types including NUMERIC, CHARACTER, DATETIME (DATE, TIMESTAMP), INTERVALS and BINARY (RAW, LONG RAW, BLOB) Ability to select different types of data insertion: through INSERT or MERGE Generation of data for several tables from different database schemes Different generation types for each field including list, random and incremental generation, generation into two and more fields simultaneously Ability to use SQL query results as a list of values for data generation Ability to preview the generated data Automatic control over referential integrity for linked tables Ability to disable triggers of the generated tables during the generation process Wide variety of generation parameters for each field type Ability to set NULL values for certain percent of cases Ability to save all generation parameters set on current wizard session into a configuration file Command-line utility to generate data using the template file What"s new in Data Generator 3.0? Unicode support is implemented. Added new options for data generation to SQL script: SQL script can be appended to an existing file; Added the possibility to select the data insertion type: INSERT, UPDATE OR INSERT (for Firebird), MERGE (for Firebird and Oracle). Added options allowing you to disable triggers associated with tables during data generation (for IB/FB, SQL Server, Oracle). 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. Added options for generating data into dependent fields with the relation 1:n (n records will be generated into the dependent table field for each record of the primary table). Data generation is now performed within a separate thread. Other improvements and bugfixes. We hope you"ll enjoy working with our products!
Source: http://www.sqlmanager.net/products/oracle/datagenerator/news/1360