oracle设置自增
来源:互联网 发布:网络通信平台 编辑:程序博客网 时间:2024/06/11 03:35
//建表
drop table GUIDE_DATA;
create table GUIDE_DATA(
id number(11) not null,
detail varchar2(500) not null,
type_id varchar2(10),
subType_id varchar2(10),
user_id varchar2(10),
create_date Date,
constraint guide_pk primary key (id)
create table GUIDE_DATA(
id number(11) not null,
detail varchar2(500) not null,
type_id varchar2(10),
subType_id varchar2(10),
user_id varchar2(10),
create_date Date,
constraint guide_pk primary key (id)
);
//建seq
create sequence guide_seq increment by 1 start with 1 nomaxvalue nocycle cache 10;
create sequence guide_seq increment by 1 start with 1 nomaxvalue nocycle cache 10;
//建触发器,新增时触发
create or replace trigger guide_trigger
create or replace trigger guide_trigger
before insert on GUIDE_DATA for each row
begin
select guide_seq.nextval into :new.id from dual;
end;
//插入数据实验
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('111detail','0034','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('222detail','0035','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('333detail','0036','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('444detail','0037','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('555detail','0034','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('666detail','0034','393040','zl',sysdate);
commit;
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('222detail','0035','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('333detail','0036','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('444detail','0037','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('555detail','0034','393040','zl',sysdate);
insert into guide_data(detail, type_id, subType_id, user_id, create_date) values('666detail','0034','393040','zl',sysdate);
commit;
------------------------------------------------------------------------------------------------------------------------------------------------------------
//删除seq
DROP SEQUENCE guide_seq;
//删除seq
DROP SEQUENCE guide_seq;
0 0
- oracle设置自增
- 【Oracle】设置自增
- Oracle自增字段设置
- Oracle 设置自增主键
- 设置Oracle主键自增
- oracle设置主键自增
- oracle自增字段设置
- Oracle 设置自增ID
- oracle 设置自增字段
- Oracle自增主键设置
- oracle设置自增字段,oracle序列
- oracle中设置自增主键
- oracle中设置自增主键
- oracle中设置自增主键
- oracle中如何设置自增字段
- oracle中设置自增主键简化
- oracle中设置自增主键
- oracle数据库自增字段的设置
- String 赋值 的漏洞
- 基于 PostgreSQL 的集群数据库 CitusDB
- partial_sum
- codeforces 573E
- 笔试练习三
- oracle设置自增
- html文本框不可编辑,禁止用户修改的几种方法
- java中MD5加密Demo
- all_of, any_of, none_of
- Struts中对数据操作方式
- 类的基本知识总结
- Ubuntu下安装fastboot的时候出现 未发现软件包
- C语言文件读写操作
- 局域网内Windows使用RealVNC远程连接CentOS6.5桌面