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 / 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
What are the two types of exceptions.
What is difference between function and trigger?
i have some prob lem to tell me about my self in interview first round ...
What is clause?
How to change sql*plus system settings?
Can I create table without primary key?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is the most restrictive isolation level? : Transact sql
What is execute immediate?
How is data stored on a disk?
Can we insert in sql function?
How can triggers be used for the table auditing?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are commit, rollback, and savepoint?
how many tables will create when we create table, what are they? : Sql dba