it will gives result as 1 and null

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

Question Posted / kuldeep123

2 Answers
8705 Views
Fintellix, I also Faced
E-Mail Answers

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 is dialect in sql?

954

What sql does db2 use?

987

Is coalesce faster than isnull?

975

Which constraints we can use while creating database in sql?

1092

Why we use pl sql?

968

Is sql a scripting language?

1025

Is pl sql different from sql?

1008

What are different methods to trace the pl/sql code?

1128

What is bulk collect in pl sql?

1102

What is a database? Explain

1117

Can we create foreign key without primary key?

991

what are aggregate and scalar functions? : Sql dba

1063

Can we commit in trigger?

987

What is clause in sql?

1119

What is sql basics?

1047