-- 创建比赛场地表
create table tb_Stadium(
StadiumId number primary key,
StadiumName varchar2(200),
StadiumAddress varchar2(200),
StadiumRe varchar2(200)
);
--创建门票表
create table tb_Tickte(
TicketId number primary key,
TicketName varchar2(200),
StadiumId number,
BeginTime date,
TotalCount number,
OrderCount number,
Price number,
TicketRe varchar2(200),
constraint tb_Tickte_wj foreign key(StadiumId) references tb_Stadium(StadiumId)
);
--创建比赛项目表
create table tb_Order(
OrderId number primary key,
TicketId number,
IDCard varchar2(200),
constraint tb_Order_wj foreign key(TicketId) references tb_Tickte(TicketId)
);
--创建序列
create sequence StadiumID;
create sequence TicketID;
create sequence OrderID;--自动增长列
Create OR Replace trigger tri_stadium_id
Before Insert On tb_Stadium
for each row
Declare
i number;
Begin
Select StadiumID.Nextval into i from dual;
:new.id:=i;
End;Create OR Replace trigger tri_ticket_id
Before Insert On tb_Tickte
for each row
Declare
i number;
Begin
Select TicketID.Nextval into i from dual;
:new.id:=i;
End;Create OR Replace trigger tri_order_id
Before Insert On tb_Order
for each row
Declare
i number;
Begin
Select OrderID.Nextval into i from dual;
:new.id:=i;
End;在建触发器的时候报
Warning: Trigger created with compilation errors
create table tb_Stadium(
StadiumId number primary key,
StadiumName varchar2(200),
StadiumAddress varchar2(200),
StadiumRe varchar2(200)
);
--创建门票表
create table tb_Tickte(
TicketId number primary key,
TicketName varchar2(200),
StadiumId number,
BeginTime date,
TotalCount number,
OrderCount number,
Price number,
TicketRe varchar2(200),
constraint tb_Tickte_wj foreign key(StadiumId) references tb_Stadium(StadiumId)
);
--创建比赛项目表
create table tb_Order(
OrderId number primary key,
TicketId number,
IDCard varchar2(200),
constraint tb_Order_wj foreign key(TicketId) references tb_Tickte(TicketId)
);
--创建序列
create sequence StadiumID;
create sequence TicketID;
create sequence OrderID;--自动增长列
Create OR Replace trigger tri_stadium_id
Before Insert On tb_Stadium
for each row
Declare
i number;
Begin
Select StadiumID.Nextval into i from dual;
:new.id:=i;
End;Create OR Replace trigger tri_ticket_id
Before Insert On tb_Tickte
for each row
Declare
i number;
Begin
Select TicketID.Nextval into i from dual;
:new.id:=i;
End;Create OR Replace trigger tri_order_id
Before Insert On tb_Order
for each row
Declare
i number;
Begin
Select OrderID.Nextval into i from dual;
:new.id:=i;
End;在建触发器的时候报
Warning: Trigger created with compilation errors
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货