测试

1、创建数据库：

 1 -- Create table
 2 create table SCHOOL
 3 (
 4   studentno VARCHAR2(40) not null,
 5   name      VARCHAR2(10),
 6   age       NUMBER,
 7   classname VARCHAR2(40)
 8 )
 9 tablespace ABC
10   pctfree 10
11   initrans 1
12   maxtrans 255
13   storage
14   (
15     initial 64K
16     next 8K
17     minextents 1
18     maxextents unlimited
19   );
20 -- Add comments to the columns 
21 comment on column SCHOOL.studentno
22   is '学号';
23 comment on column SCHOOL.name
24   is '姓名';
25 comment on column SCHOOL.age
26   is '年龄';
27 comment on column SCHOOL.classname
28   is '班级';

2、插入数据：

1 insert into school values ('201623801','小王',21,'238'）;
2 insert into school values ('201623802','小李',21,'238'）;
3 insert into school values ('201623803','小赵',21,'238'）;
4 insert into school values ('201623804','小钱',22,'238'）;
5 insert into school values ('201623805','小孙',22,'238'）;
6 insert into school values ('201623806','小周',22,'238'）;
7 insert into school values ('201623807','小吴',23,'238'）;
8 insert into school values ('201623808','小王',23,'238'）;

View Code

 

转载于:https://www.cnblogs.com/wangfeihu/p/5755804.html