Question

oracle练习。用SQL语句建表

创建客户表customer
(1)1客户编号(数字类型)，2客户名称(可变字符类型)，3客户电话(可变字符类型)
(2)往客户表中插入十条数据

(3)分页查询第二页数据(每页显示3条数据)

Answer 1

(1)
create table customer(
"客户编号" number(8),
"客户名称" varchar2(40),
"客户电话" varchar2(20)
);
(2)
insert into customer values(1,'客户1','13900000001');
insert into customer values(2,'客户2','13900000002');
insert into customer values(3,'客户3','13900000003');
insert into customer values(4,'客户4','13900000004');
insert into customer values(5,'客户5','13900000005');
insert into customer values(6,'客户6','13900000006');
insert into customer values(7,'客户7','13900000007');
insert into customer values(8,'客户8','13900000008');
insert into customer values(9,'客户9','13900000009');
insert into customer values(10,'客户10','13900000010');
(3)
select * from customer where rownum>=4 and rownum<=6;