Hello folks,
my requirement is: Given a number N (let's say 7 for this example) generate a query with following output:
SELECT A,B FROM some_query
/
A B
-------
1 7
1 7
1 7
1 7
1 7
1 7
1 7
2 6
2 6
2 6
2 6
2 6
2 6
3 5
3 5
3 5
3 5
3 5
4 4
4 4
4 4
4 4
5 3
5 3
5 3
6 2
6 2
7 1
28 rows selected.
Any ideas?