oracle将一行数据in,用in如何就出现一行数据-CSDN博客

这篇博客内容涉及数据库操作，具体为向'deptment'和'class_table'表中插入数据，涵盖了数学、计算机、中文和经济学四个部门，以及多个课程的详细信息，包括课程名、所属部门、入学时间和学生人数。

摘要由CSDN通过智能技术生成

SQL codeinsert into deptment(dept_id,dept_name)values('1','数学');

insert into deptment(dept_id,dept_name)values('2','计算机');

insert into deptment(dept_id,dept_name)values('3','中文');

insert into deptment(dept_id,dept_name)values('4','经济学');

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('101','软件','计算机','1995',20);

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('102','微电子','计算机','1996',30);

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('111','无机化学','化学','1995',29);

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('112','高分子化学','化学','1996',25);

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('121','统计','数学','1995',20);

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('141','国际贸易','金融学','1997',30);

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('131','现代汉语','中文','1996',20);

insert into class_table(class_id,subject_name,dept_name,entertime,person_num)values('151','国际汉语','金融学','1996',14);