Get the following OUTPUT using dual  

  RSS

Demon
(@demonguru)
Member Admin
Joined:5 years  ago
Posts: 40
25/04/2018 2:27 pm  

1 L R
—————
1 1 1
1 1 2
1 1 3
1 2 1
1 2 2
1 2 3
1 3 1
1 3 2
1 3 3


SELECT * FROM

(SELECT 1 FROM dual),

(SELECT LEVEL l FROM dual CONNECT BY LEVEL <4),

(SELECT LEVEL r FROM dual CONNECT BY LEVEL <4);

DemonGuru18


ReplyQuote
Share: