Oracle 序列

最新推荐文章于 2024-07-11 08:38:54 发布

chaoyv

最新推荐文章于 2024-07-11 08:38:54 发布

阅读量87

点赞数

分类专栏： Hibernate 文章标签：数据库

本文链接：https://blog.csdn.net/chaoyv/article/details/88303050

版权

Hibernate 专栏收录该内容

70 篇文章 0 订阅

订阅专栏

employee_SYS_GUID

/*
===========================================================
|          SYS_GUID函数
============================================================
*/

SELECT SYS_GUID() FROM dual;

--empno 列数据类型为char(32)
INSERT INTO EMPLOYEE VALUES
(SYS_GUID(),'张三','CLERK',7902,to_date('07-10-2013','dd-mm-yyyy'),5800,NULL,20);

employee序列

/*
===========================================================
|          序列
============================================================
*/

CREATE SEQUENCE emp_seq
START WITH 8000
INCREMENT BY 1
NOMAXVALUE 
NOCYCLE
CACHE 30;

INSERT INTO EMPLOYEE VALUES
(emp_seq.NEXTVAL,'张三','CLERK',7902,to_date('07-10-2013','dd-mm-yyyy'),5800,NULL,20);