Get the following OUTPUT using dual

Last Post

RSS

Demon

(@demonguru)

Member Admin

Joined: 7 years ago

Posts: 36

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

Quote

Forum Statistics

3 Forums

111 Topics

111 Posts

0 Online

35.6 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts Mark all read

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Techhowdy Forum