日期:2014-05-16 浏览次数:20548 次
Table:
CREATE TABLE TEST_A
(
ID NUMBER NOT NULL,
NAME CHAR(200),
ADDRESS CHAR(200),
CONSTRAINT ID PRIMARY KEY (ID)
)
?
Sequence:
create sequence S_TEST_A minvalue 1 maxvalue 9999999999999999999999999999 start with 21 increment by 1 cache 20;
?
Trigger:
create or replace trigger "test_a_trigger" before
insert on TEST_A for each row
when (new.id is null)
begin
select S_TEST_A.nextval into:new.id from dual;
end;
??
?