17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tb_student(
ID VARCHAR2(8) PRIMARY KEY NOT NULL,--学生ID
NAME VARCHAR2(20),--学生姓名
age VARCHAR2(5),--年龄
address VARCHAR2(100),--地址
class_id);--班级ID
INSERT INTO tb_student VALUES('10010001','测试01','12','安宁西路18号','10003');
INSERT INTO tb_student VALUES('10010002','测试02','15','安宁西路18号','10003');
INSERT INTO tb_student VALUES('10010003','测试03','11','安宁西路18号','10001');
INSERT INTO tb_student VALUES('10010004','测试04','12','安宁西路18号','10004');
INSERT INTO tb_student VALUES('10010005','测试05','10','安宁西路18号','10001');
INSERT INTO tb_student VALUES('10010006','测试06','13','安宁西路18号','10005');
INSERT INTO tb_student VALUES('10010007','测试07','15','安宁西路18号','10003');
INSERT INTO tb_student VALUES('10010008','测试08','12','安宁西路18号','10004');
INSERT INTO tb_student VALUES('10010009','测试09','12','安宁西路18号','10001');
INSERT INTO tb_student VALUES('10010010','测试10','13','安宁西路18号','10002');
INSERT INTO tb_student VALUES('10010011','测试11','12','安宁西路18号','10004');
INSERT INTO tb_student VALUES('10010012','测试12','13','安宁西路18号','10003');
INSERT INTO tb_student VALUES('10010013','测试13','12','安宁西路18号','10002');
INSERT INTO tb_student VALUES('10010014','测试14','14','安宁西路18号','10002');
INSERT INTO tb_student VALUES('10010015','测试15','13','安宁西路18号','10005');
INSERT INTO tb_student VALUES('10010016','测试16','12','安宁西路18号','10001');