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

How to convert comma separated string to array in pl/sql?

573


What is a join query?

533


What is the use of procedures?

512


What does the base_object_type column shows in the user.triggers data dictionary view?

546


what is a composite key ? : Sql dba

565






What is a natural join?

488


How do you create a unique index?

537


Is sql between inclusive?

563


how to use like conditions? : Sql dba

543


What does cursor do in sql?

494


How do I find duplicates in the same column?

508


What is sql profiling in oracle?

517


Is id a reserved word in sql?

628


Show the cursor attributes of pl/sql.

584


How many types of keys are there in sql?

528