CREATE TABLE t
(
  x NUMBER PRIMARY KEY,
  y NUMBER,
  z NUMBER
);

CREATE TABLE s
(
  x NUMBER PRIMARY KEY
);

INSERT ALL
  INTO t ( x, y, z )
  VALUES ( myrownum, ran1, ran2 )
  INTO s ( x )
  VALUES ( myrownum )
SELECT 
  rownum myrownum,
  dbms_random.value ran1,
  dbms_random.value ran2
FROM dual
  CONNECT BY LEVEL < 101;

CJUSTICE@ORA10GR2>SELECT COUNT(*) FROM t;

  COUNT(*)
----------
       100

1 row selected.

Elapsed: 00:00:00.01
CJUSTICE@ORA10GR2>SELECT COUNT(*) FROM s;

  COUNT(*)
----------
       100

1 row selected.

Elapsed: 00:00:00.02

Labels: database, datawarehouse, sql

¶ 5/21/2008 05:17:00 PM