【oracle】“+”函数的用法

CREATE TABLE man (

id number,

name VARCHAR2(10),

sex  VARCHAR2(10)

);

CREATE TABLE woman (

id number,

name VARCHAR2(10),

sex  VARCHAR2(10)

);

INSERT INTO man VALUES(1,'爱国',1);

INSERT INTO man VALUES(2,'援朝',1);

INSERT INTO man VALUES(3,'跃进',1);

INSERT INTO man VALUES(4,'超美',1);

INSERT INTO man VALUES(5,'卫国',1);

INSERT INTO woman VALUES(1,'倩倩'，0);

INSERT INTO woman VALUES(1,'娇娇'，0);

INSERT INTO woman VALUES(2,'丽丽', 0);

INSERT INTO woman VALUES(1,'青青', 0);

INSERT INTO woman VALUES(7,'莲莲', 0);

select *  from man;

select *  from woman  for update

--左外连接

select m.*,w.* from   man m left join  woman w on m.id=w.id;

select *  from  man m, woman w where  m.id=w.id(+);

--右外连接

select m.*,w.* from  man m right join woman w on m.id=w.id

select m.*,w.* from  man m,woman w where m.id(+)=w.id;