oracle中的交集，并集差集小结

-- Create table
create table T_STUDENT
(
  ID   VARCHAR2(10),
  NAME VARCHAR2(50)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

INSERT INTO T_STUDENT (ID, NAME) VALUES ('1', 'Kavins');

INSERT INTO T_STUDENT (ID, NAME) VALUES ('2', 'Bob');

INSERT INTO T_STUDENT (ID, NAME) VALUES ('3', 'Tom');

INSERT INTO T_STUDENT (ID, NAME) VALUES ('4', 'Mary');

INSERT INTO T_STUDENT (ID, NAME) VALUES ('5', 'Ives');

INSERT INTO T_STUDENT (ID, NAME) VALUES ('6', 'Smith');

INSERT INTO T_STUDENT (ID, NAME) VALUES ('7', 'Mari');

INSERT INTO T_STUDENT (ID, NAME) VALUES ('8', 'Teddy');

-- Create table
create table T_STUDENT2
(
  ID     VARCHAR2(10),
  GENDER VARCHAR2(50),
  AGE    VARCHAR2(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16
    next 8
    minextents 1
    maxextents unlimited
  );