oracle 通过触发器和sequence 实现字段自增
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHAR(25),
PHONE VARCHAR(10),
ADDRESS VARCHAR(50) );create sequence foo_seq;
drop trigger first_trigger;commit;
CREATE or replace TRIG
转载
2010-11-22 14:52:00 ·
734 阅读 ·
0 评论