14c02-1.sql

来自「介绍PHP5的给类型函数应用」· SQL 代码 · 共 29 行

create sequence TOOLS_ID
start with 1
increment by 1
nomaxvalue
go

create table TOOLS (
	ID   number(10)    not null,
	DESC varchar2(255) not null,
	QTY  number(8)     not null
    constraint TOOLS_PK primary key(ID)
)
go

create or replace trigger TOOLS_IDTRIG
before insert on TOOLS
for each row
begin
select TOOLS_ID.nextval into :new.ID from dual;
end;
go

insert into TOOLS (DESC, QTY) values ('Screwdriver', 10)
go
insert into TOOLS (DESC, QTY) values ('Tablesaw', 1)
go
insert into TOOLS (DESC, QTY) values ('Router', 2)
go