SELECT 1, L, R FROM (SELECT LEVEL R FROM DUAL CONNECT BY LEVEL<=3), (SEL

Write the sql query using dual table for below output?

1 L R
--- --- ----
1 1 1
1 2 1
1 3 1
1 1 2
1 2 2
1 3 2
1 1 3
1 2 3
1 3 3

Write a query using only Dual table with out writing any pl/sql program.

Question Posted / abilash reddy

3 Answers
10359 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answer Posted / abilash reddy

SELECT 1, L, R FROM (SELECT LEVEL R FROM DUAL CONNECT BY LEVEL<=3), (SELECT LEVEL L FROM DUAL CONNECT BY LEVEL<=3);

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is string data type in sql?

1050

What is a function in oracle pl sql?

975

What is difference between nchar and nvarchar?

956

what is an alias command? : Sql dba

1007

What is function and procedure in pl sql?

970

What are the basic sql commands?

1037

Explain character-manipulation functions?

1067

how to enter numeric values as hex numbers? : Sql dba

1006

Is inner join faster than left join?

1124

how to extract a unit value from a date and time? : Sql dba

945

What is a constraint? Tell me about its various levels.

1082

How many triggers can be applied to a table?

993

What is the difference between microsoft sql and mysql?

920

What is the requirement of self-join?

1025

Can we perform dml in function?

1014