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

Can we create database in oracle using command line ?

How to use "while" statements in oracle?

How to write an inner join with the where clause in oracle?

What are the execution control statements in oracle?

what are the disadvantages of hierarchial database over RDBMS?

What is a sub query? Describe its types?

find the second highest salary of the emp table

Which is faster join or subquery in oracle?

What is the usage of merge statement?

Where is the export dump file located?

how do get database name at sql prompt?

What is format trigger?

For more Oracle General Interview Questions Click Here