clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591492 fiddles created (45736 in the last week).

create table test (Id char);
 hidden batch(es)


insert into test values('A');
1 rows affected
 hidden batch(es)


insert into test values('B');
1 rows affected
 hidden batch(es)


insert into test values('C');
1 rows affected
 hidden batch(es)


insert into test values('D');
1 rows affected
 hidden batch(es)


insert into test values('E');
1 rows affected
 hidden batch(es)


SELECT id, PRIOR id AS id2 FROM test WHERE LEVEL = 2 CONNECT BY NOCYCLE PRIOR id > id ORDER BY id, id2
ID ID2
A B
A C
A D
A E
B C
B D
B E
C D
C E
D E
 hidden batch(es)