Oracle-建表student

最新推荐文章于 2024-01-26 12:09:33 发布

weixin_30872789

最新推荐文章于 2024-01-26 12:09:33 发布

阅读量644

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/miss123/p/5567392.html

版权

新建学生表student，并添加数据

 1 -- Create table
 2 create table STUDENT
 3 (
 4   sno       VARCHAR2(3) not null,
 5   sname     VARCHAR2(8) not null,
 6   ssex      VARCHAR2(2) not null,
 7   sbirthday DATE,
 8   class     VARCHAR2(5)
 9 )
10 tablespace TEST
11   pctfree 10
12   initrans 1
13   maxtrans 255
14   storage
15   (
16     initial 64K
17     next 1M
18     minextents 1
19     maxextents unlimited
20   );
21 -- Add comments to the table 
22 comment on table STUDENT
23   is '学生表';
24 -- Add comments to the columns 
25 comment on column STUDENT.sno
26   is '学号（主键）';
27 comment on column STUDENT.sname
28   is '学生姓名';
29 comment on column STUDENT.ssex
30   is '学生性别';
31 comment on column STUDENT.sbirthday
32   is '学生出生年月';
33 comment on column STUDENT.class
34   is '学生所在班级';