René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

ANSI joins in Oracle

select col_1, ... col_n from table_1       join table_2 on col_x  = col_y
select col_1, ... col_n from table_1 inner join table_2 on col_x  = col_y

select col_1, ... col_n from table_1       join table_2 using (col_x, col_y...)
select col_1, ... col_n from table_1 inner join table_2 using (col_x, col_y...)

select col_1, ... col_n from table_1 natural       join table_2
select col_1, ... col_n from table_1 natural inner join table_2
select col_1, ... col_n from table_1 cross join table_2
select col_1, ... col_n from table_1 left        join table_2 on col_x  = col_y
select col_1, ... col_n from table_1 left  outer join table_2 on col_x  = col_y

select col_1, ... col_n from table_1 right       join table_2 on col_x  = col_y
select col_1, ... col_n from table_1 right outer join table_2 on col_x  = col_y

select col_1, ... col_n from table_1 full        join table_2 on col_x  = col_y
select col_1, ... col_n from table_1 full  outer join table_2 on col_x  = col_y

select col_1, ... col_n from table_1 left        join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 left  outer join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 right       join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 right outer join table_2 using(col_x, col_y...)

select col_1, ... col_n from table_1 full        join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 full  outer join table_2 using(col_x, col_y...)
Natural join:
select col_1, ... col_n from table_1 natural     join table_2