Get the following OUTPUT using dual

Last Post

RSS

Demon

(@demonguru)

Member Admin

Joined: 5 years ago

Posts: 41

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

Forum Statistics

4 Forums

270 Topics

271 Posts

0 Online

13.3 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