INSERT INTO PS_SOME_TEST_TBL
SELECT EMPLID, 'Test ID'
FROM
(SELECT EMPLID FROM PS_JOB
ORDER BY DBMS_RANDOM.VALUE)
WHERE ROWNUM < 101;
Inserting Random Test Data
Posted by
Michael Nitschke
on Tuesday, 10 August 2010
Labels:
test sql random
0 comments:
Post a Comment