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

Answer Posted / kuldeep123

it will gives result as 1 and null

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the disadvantages of not performing database normalization?

595


How does cross join work?

502


How do I pipe the output of one isql to another?

530


Can you join a table to itself?

540


How do you run a query?

587






Why do we use %rowtype & %type in plsql?

601


Are left and right joins the same?

529


What is a record in a database?

559


What are the uses of merge?

717


What are triggers and its uses?

593


Define SQL and state the differences between SQL and other conventional programming Languages?

679


What are the different dml commands in sql?

584


What is nosql vs sql?

565


What are different sql data types?

513


What is a sql instance vs database?

572