oracle更新某个字段加1,关于ORACLE中创建某个字段中值自动加1的方法实例实现

关于ORACLE中创建某个字段中值自动加1的方法

实现步骤(在SQL PLUS中进行操作)：

1.创建表(sql语句)：

create table Term_register

(

ID integer not null,

Province_ID VARCHAR2(2) default ' ' not null,

City_ID VARCHAR2(4) default ' ' not null,

Manufacturers_ID VARCHAR2(5) default ' ' not null,

Terminal_Type CHAR(8) default ' ' not null,

Terminal_ID VARCHAR2(7) default ' ' not null,

);

comment on table Term_register

is '终端注册表';

comment on column Term_register.ID

is '终端编号';

comment on column Term_register.Province_ID

is '省域ID';

comment on column Term_register.City_ID

is '市县域ID';

comment on column Term_register.Manufacturers_ID

is '制造商ID';

comment on column Term_register.Terminal_Type

is '终端型号';

comment on column Term_register.Terminal_ID

is '终端ID';

alter table Term_register

add primary key (ID);

2.创建系列：

create sequence term_reg_sequ

start with 1

increment by 1;

3.创建触发器：

CREATE OR REPLACE TRIGGER term_reg_trig

BEFORE INSERT ON term_register

FOR EACH ROW

declare

next_checkup_no number;

begin

select term_reg_sequ.nextval