数据库练习（二）

最新推荐文章于 2024-09-25 09:21:39 发布

花开时节多风雨

最新推荐文章于 2024-09-25 09:21:39 发布

阅读量801

点赞数 4

分类专栏：数据库文章标签： Oracle 数据库

本文链接：https://blog.csdn.net/CNZSWYMP/article/details/86148384

版权

这篇博客主要介绍了使用Oracle数据库进行建表操作，包括创建teacher、student和classes三张表，并进行了数据插入，为后续的数据库练习奠定了基础。

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

建表 teacher ,student ,classes

create table teacher(
   tno varchar2(30) primary key ,
   tname varchar2(50),
   tsex varchar2(5),
   tage number(3),
   tsal number(6,2),
   tpostion varchar2(30),
   cno varchar2(30)
);

create table classes(
   cno varchar2(30) primary key,
   cname varchar(100)
);

create table STUDENT
(
  SNO      VARCHAR2(20) primary key,
  SNAME    VARCHAR2(30) not null,
  SEX      VARCHAR2(10),
  AGE      NUMBER(3),
  CNO    VARCHAR2(30)
);

准备工作插入数据

--1、给teacher表添加20条记录，要求有3条记录cno没有值，2条记录cno的值与Classes表中的cno值不匹配，剩余15条记录的cno取 Classes表中的部分cno，不要全取
insert into teacher values('t0001','李累','男','28','2348.65','讲师','');
insert into teacher values('t0002','孙丽','女','26','3348.65','讲师','');
insert into teacher values('t0003','王伟','男','36','6348.65','教授','');
insert into teacher values('t0004','李刚','男','34','4348.65','讲师','c0008');
insert into teacher values('t0005','刘艳','女','28','4348.65','讲师','c0010');

insert into teacher values('t0006','李磊','男','28','2348.65','讲师','c0001');
insert into teacher values('t0007','杨磊','男','32','1348.65','讲师','c0002');
insert into teacher values('t0008','赵超','男','36','6348.65','教授','c0003');
insert into teacher values('t0009','张超','男','34','9348.65','讲师','c0004');
insert into teacher values('t0010','江燕','女','24','4348.65','讲师','c0005');

insert into teacher values('t0011','孙伟超','男','28','5148.65','讲师','c0006');
insert into teacher values('t0012','杨丽荣','男','32','948.65','讲师','c0002');
insert into teacher values('t0013','刘子杰','男','36','7348.65','教授','c0003');
insert into teacher values('t0014','钱学森','男','68','9999.9','教授','c0004');
insert into teacher values('t0015','江一燕','女','20','3348.65','讲师','c0006');

insert into teacher values('t0016','小鱼儿','男','18','5148.65','讲师','c0001');
insert into teacher values('t0017