help needed regarding the use of outer joins

Using Outer Joins[^]
It return all rows from at least one of the tables or views mentioned in the FROM clause, as long as those rows meet any WHERE or HAVING search conditions.
All rows are retrieved from the left table referenced with a left outer join, and all rows from the right table referenced in a right outer join.

All rows from both tables are returned in a full outer join.

Where to use outer joins?[^]
What is SQL OUTER JOIN[^]

Outer Joins can primarily be considered to be of two types - left and right outer joins.

A left outer join is used when you want all rows in the first table and joined rows from the second table.

A right outer join is used when you want all rows in the second table and joined rows from the first table.

Lets say you have two tables

Table A

Id  Name
1   A
2   B
3   C

Table B

Id  Name  Rank
1   B     1
2   D     2
3   E     3

If you use left outer on these tables by using a query like

select A.Name, B.Rank from table1 A left join table B on A.Name = B.Name

your output would be -

Name Rank
A      
B      2
C

Only the rank for B was returned, however rows for the first table were still returned.

if oracle 6i means use + symbol
ex : select * from emp,dept
where emp_dept_id = dept_id(+)

if oracle 10g means use keyword outer join.

Refer the link:

http://www.techonthenet.com/oracle/joins.php[^]