oracle的sql练习题

A. oracle练习。用SQL语句建表

(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;

B. Oracle嵌套表问题 PL/SQL

1.create table(PName varchar(20))
select distinct PName from Patient;

2.create table
select * from Patient

然后对Patient增加两个trigger
1.if(:New.DName not in Patient) insert 嵌套表1
2.on update insert ,insert 嵌套表2