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
8558 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

How you improve the performance of sql*loader? : aql loader

954

What is the command used to fetch the first 5 characters of a string?

1149

Does view store data in sql?

895

Can ddl statements be used in pl/sql?

1065

Explain what is sql?

1050

how can you create an empty table from an existing table? : Sql dba

1076

What is pl sql code?

987

What is AUTH_ID and AUTH_USER in pl/sql ?

2134

what are properties of a transaction? : Sql dba

1015

What are the different types of constraints?

1066

Why do we use procedures in pl sql?

957

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

897

What does pl sql developer do?

878

How to make a copy values from one column to another in sql?

978

Explain the working of foreign key?

974