sql - Merge column with random values -
i'm trying generate random values, there problems don't know how handle with. sql:
select * (select round(dbms_random.value(1000000000,10000000000)) num dual connect rownum < x), (select round(dbms_random.value(1,5)) num1 dual)
for output looks:
1241511501 2 1515628080 2 1798442549 4 4061575813 2 5673495016 3 6582052088 5 7672299459 5 9360968960 5 9618384703 4
i looks:
1241511501 5 1515628080 5 1798442549 5 4061575813 5 5673495016 5 6582052088 5 7672299459 5 9360968960 5 9618384703 5
of course number "5" optional, should random number.
try this:
select * (select round(dbms_random.value(1000000000,10000000000)) num dual connect rownum < 10), (select round(dbms_random.value(1,5)) num1 dual connect rownum = 1)
Comments
Post a Comment