在论坛上看到一个问题,自己以前也遇到过,像是一个老友,又熟悉又陌生,内心愧疚,赶紧去实际验证,然后记录在这里给自己提个醒。
首先创建两张表A,B,并插入数据,
create table A (
ID number(4),
NAME varchar2(10));
comment on column A.ID is '学号';
comment on column A.NAME is '姓名';
insert into A (ID,NAME) values ('1','张三');
insert into A (ID,NAME) values ('2','李四');
insert into A (ID,NAME) values ('3','王五');
create table B (
XUEH VARCHAR2(10),
SUBJECT varchar2(10));
comment on column B.XUEH is '学号';
comment on column B.SUBJECT is '学科';
insert into B (XUEH,SUBJECT) values ('1,2','语文');
insert into B (XUEH,SUBJECT) values ('2,3','数学');
insert into B (XUEH,SUBJECT) values ('1,2,3','物理');
insert into B (XUEH,SUBJECT) values ('1,3','英语');
insert into B (XUEH,SUBJECT) values ('1','生物');
目标要实现以下的结果: