Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Test Data

Re: Test Data

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Tue, 22 Jan 2002 10:45:10 +0500
Message-ID: <a2iu9c$10m7go$1@ID-127142.news.dfncis.de>


> Does anyone know of a program that generates test data for multiple
> tables. I need the usual data types, text, date, integer, real.

Hi,
you can create just a simple PL/SQL procedure to generate random data (for example using DBMS_RANDOM package).
Or another way, to select appropriate data from database dictionary tables into yours.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com
Received on Mon Jan 21 2002 - 23:45:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US