Oracle SQL to print the all possible combination of numbers

 

with ds1 as (select 4 n from dual)

select * from ds1;

 

with ds1 as (select 4 n from dual)

select * from dual connect by level<=(select  n from ds1);

 

with ds1 as (select 4 n from dual)

select rownum from dual connect by level<=(select  n from ds1);

 

with ds1 as (select 4 n from dual)

,ds2 as (select rownum r from dual connect by level<=(select  n from ds1))

select * from ds2 t1 cross join ds2 t2;

 

with ds1 as (select 4 n from dual)

,ds2 as (select rownum r from dual connect by level<=(select  n from ds1))

select t1.r,t2.r from ds2 t1 cross join ds2 t2

where t2.r>t1.r;

 

with ds1 as (select 4 n from dual)

,ds2 as (select rownum r from dual connect by level<=(select  n from ds1))

select '['||t1.r||','||t2.r||']' from ds2 t1 cross join ds2 t2

where t2.r>t1.r;

 

with ds1 as (select 4 n from dual)

,ds2 as (select rownum r from dual connect by level<=(select  n from ds1))

select listagg('['||t1.r||','||t2.r||']') within group (order by t1.r,t2.r) from ds2 t1 cross join ds2 t2

where t2.r>t1.r;