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.
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
What is online transaction processing (oltp)?
What is sqlite used for?
What is snowflake sql?
Is sqlexception checked or unchecked?
What is sql integrity?
What is a field in a database?
How do I clear the screen in sql plus?
Can we rename a column in the output of sql query?
what does it mean to have quoted_identifier on? : Sql dba
how to shutdown mysql server? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
Is stored procedure faster than query?
What is hibernate and its relation to sql?
How to display the current date in sql?
What is the difference between explicit and implicit cursors in oracle?