Oracle 序列

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);