with t as (
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual union all
select trunc(10000 * dbms_random.value) val, ' ' as grp from dual
)
select * from t

with t as (
select 842854 as val, ' ' as grp from dual union all
select 223635 as val, ' ' as grp from dual union all
select 792677 as val, ' ' as grp from dual union all
select 982181 as val, ' ' as grp from dual union all
select 729349 as val, ' ' as grp from dual union all
select 427755 as val, ' ' as grp from dual union all
select 572896 as val, ' ' as grp from dual union all
select 921370 as val, ' ' as grp from dual union all
select 47618 as val, ' ' as grp from dual union all
select 836077 as val, ' ' as grp from dual union all
select 623391 as val, ' ' as grp from dual union all
select 235966 as val, ' ' as grp from dual union all
select 676862 as val, ' ' as grp from dual union all
select 643398 as val, ' ' as grp from dual union all
select 125684 as val, ' ' as grp from dual union all
select 179640 as val, ' ' as grp from dual union all
select 719781 as val, ' ' as grp from dual union all
select 872850 as val, ' ' as grp from dual union all
select 978958 as val, ' ' as grp from dual union all
select 960144 as val, ' ' as grp from dual union all
select 88590 as val, ' ' as grp from dual union all
select 830416 as val, ' ' as grp from dual union all
select 689889 as val, ' ' as grp from dual union all
select 798929 as val, ' ' as grp from dual union all
select 707491 as val, ' ' as grp from dual union all
select 766289 as val, ' ' as grp from dual union all
select 193738 as val, ' ' as grp from dual union all
select 382435 as val, ' ' as grp from dual union all
select 407950 as val, ' ' as grp from dual union all
select 398201 as val, ' ' as grp from dual
) select * from t

LDM