How to write a query with a full outer join in oracle?

Question Posted / lokendra singh

How to write a query with a full outer join in oracle?..

Answer / guest

select * from t1 full outer join t2

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

How to upsert (update or insert into a table)?

What is the difference between "as" and "is" in an oracle stored procedure?

How to write a left outer join with the where clause in oracle?

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

i want department wise maxmum salary and empolyee name

How to start your 10g xe server from command line?

When do you get a .pll extension in oracle? Explain its importance

please explain.. DB architecture ...

"primary key=unique+null" is equal,reson?not,reason?

How you find out version of installed workflow?

Which are the five query types available in oracle?

How do I know if oracle is installed on windows?

For more Oracle General Interview Questions Click Here