2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A
Full outer join ( select 1 B from dual Union select 2 B from dual)B
On A.A=B.B
Post New Answer View All Answers
What are the disadvantages of not performing database normalization?
How does cross join work?
How do I pipe the output of one isql to another?
Can you join a table to itself?
How do you run a query?
Why do we use %rowtype & %type in plsql?
Are left and right joins the same?
What is a record in a database?
What are the uses of merge?
What are triggers and its uses?
Define SQL and state the differences between SQL and other conventional programming Languages?
What are the different dml commands in sql?
What is nosql vs sql?
What are different sql data types?
What is a sql instance vs database?