WITH a as (SELECT level L from DUAL CONNECT BY level <=3) SELECT 1, L,

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 / mani

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

Answer Posted / mani

WITH a as (SELECT level L from DUAL CONNECT BY level <=3)
SELECT 1, L, R
FROM (SELECT level R from DUAL CONNECT BY level <=3) b
CROSS JOIN a;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you rollback after commit?

931

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

943

how to load data files into tables with 'mysqlimport'? : Sql dba

1031

Explain the methods used to protect source code of pl/sql.

959

What is a sql trace file?

976

what is myisam? : Sql dba

999

Which certification is best for sql?

937

What is an inconsistent dependency?

978

What is cartesian join in sql?

1028

What is compute?

1010

Is oracle and sql same?

953

What is cost in sql execution plan?

902

What is information schema in sql?

1012

Explain what is a database?

1036

how to rename an existing column in a table? : Sql dba

958