ORACLEÖн¨Á¢×ÔÔö×Ö¶Î

OracleÖв»ÏñÆäËûÈçmysqlµÈÊý¾Ý¿âµÄÓÐ×ÔÔö×ֶΣ¬Èç¹ûÐèÒªÔòÐèÒª½èÖúÐòÁкʹ¥·¢Æ÷
Ê×ÏȽ¨±í
½¨Á¢ÐòÁÐ
½¨´¥·¢Æ÷
For example£º
create table SYS_MESSAGE
(
ID NUMBER not null PRIMARY KEY,
M_TYPE VARCHAR2(10) not null,
TITLE VARCHAR2(200),
CONTENT LONG,
M_TIME VARCHAR2(50),
AUTHOR VARCHAR2(20)
);
CREATE SEQUENCE SYS_MESSAGE_ID_SEQ
INCREMENT BY 1
START WITH 1
NOMAXVALUE
MINVALUE 1
CACHE 50
;

CREATE OR REPLACE TRIGGER SYS_MESSAGE_ID_TRIGGER
BEFORE INSERT ON SYS_MESSAGE
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT SYS_MESSAGE_ID_SEQ.NEXTVAL INTO:NEW.ID from DUAL;
END;