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

Is postgresql a nosql database?

1142

What is the purpose of the sql select top clause?

1088

Can we use rowid as primary key?

966

Do ddl statements need commit?

958

Why do we need view in sql?

969

Which type of cursor is used to execute the dml statement?

941

What are sql functions? Describe the different types of sql functions?

1122

Explain ttitle and btitle.

1105

What is memory optimized?

1068

Can we insert data in view?

948

Can %notfound return null after a fetch?

1040

What is over () in sql?

931

How to select unique records from a table?

1038

What is the most restrictive isolation level? : Transact sql

1069

How can you load microsoft excel data into oracle? : aql loader

1155