Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

 select
        (select * from
                (
                    select     level lvl
                    from       dual
                    connect by level <= 10
                )
            pivot (
                max(lvl)
                for lvl in (1,2,3,4,5,6,7,8,9,10)
            )
        )
    from dual
    connect by level <= 10
ORA-00913: too many values

select * from
(
    select     level lvl
    from       dual
    connect by level <= 10
)
pivot (
    max(lvl)
    for lvl in (1,2,3,4,5,6,7,8,9,10)
)


1
2
3
4
5
6
7
8
9
10


1
2
3
4
5
6
7
8
9
10


select * from
(
    select     level lvl
    from       dual
    connect by level <= 10
)
pivot (
    max(lvl)
    for lvl in (1,2,3,4,5,6,7,8,9,10)
)
connect by level <= 10


1
2
3
4
5
6
7
8
9
10


1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1
2
3
4
5
6
7
8
9
10

1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10

1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10

1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10
1	2	3	4	5	6	7	8	9	10