User Tools

Site Tools


oracle:meaningoffulljoin

This is an old revision of the document!


How does full join work???

Despite I am seasoned sql developer, sometimes I have doubts on how exactly full join work; so I decided to implement this simple test to see this working.

Let's say we have two tables:

create table test1
(field  varchar2(100));

create table test2
(field varchar2(100));

-- unique values for table test1 
insert into test1 values ('a');
insert into test1 values ('b');
insert into test1 values ('c');
oracle/meaningoffulljoin.1461743305.txt.gz · Last modified: 2016/04/27 09:48 by rlunaro