Oralce: Sequence & Trigger to Achieve Auto-Increment
来源:互联网 发布:黔东南人口数据 编辑:程序博客网 时间:2024/06/06 03:09
[内容收集自网络]
--建表
CREATE TABLE table1
(id NUMBER PRIMARY KEY,
username VARCHAR2(50));
--建序列
CREATE SEQUENCE table1_seq
MINVALUE 1
MAXVALUE 9999999999
START WITH 1
INCREMENT BY 1
CACHE 30
ORDER;
--建触发器
CREATE OR REPLACE TRIGGER table1_tg
BEFORE INSERT ON table1
FOR EACH ROW
BEGIN
SELECT table1_seq.NEXTVAL INTO :NEW.id FROM DUAL;
END;
/
--执行插入操作
INSERT INTO table1 (username) VALUES ('張三');
- Oralce: Sequence & Trigger to Achieve Auto-Increment
- Failed to read auto-increment value from storage engine
- Failed to read auto-increment value from storage engine
- MYSQL-Failed to read auto-increment value from storage engine
- Failed to read auto-increment value from storage engine
- AUTO INCREMENT Reset
- SQL AUTO INCREMENT 字段
- SQL AUTO INCREMENT 字段
- SQL AUTO INCREMENT 字段
- SQL AUTO INCREMENT 字段
- python auto-increment
- oracle auto increment
- SQL AUTO INCREMENT 字段
- SQL AUTO INCREMENT
- Sequence Trigger
- MS SQL Server - How to change an existing column to auto-increment column
- auto-increment 主键自增
- mysql auto increment特性说明
- epoll精髓
- HTML 简史
- 无题_20100518
- C++常量范围
- C++ error C2440: “类型转换” : 无法从“std::vector::iterator”转换为“PPkgHead”
- Oralce: Sequence & Trigger to Achieve Auto-Increment
- 计算地球上A B两点间距离的计算公式
- combobox实现双击事件
- 使用net命令来映射网络驱动盘
- PKU 1000 A+B 详细脑残题解~~~
- Microsoft SharePoint Server 2010 的 Total Economic ImpactTM(总体经济影响)
- 厚黑学:智者尽其谋,勇者尽其力
- VC++ 2005连接数据库
- 2010-05-17--------2010-05-23