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

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -