前言:
Oeacle中有一张cust_info表, 主键是 ID(对应的sequence是 SEQ_CUST_INFO) ,新增时间字段是INPUT_TIME(date)。现在用触发器,实现新增一条记录是主键自动自增赋值,且INPUT_TIME字段默认赋值当前时间。sql如下
--
/*
* TRG_CUST_INFO:触发器名字
* CUST_INFO:表名字
* SEQ_CUST_INFO:sequence 名字
*/
CREATE
OR REPLACE TRIGGER TRG_CUST_INFO BEFORE INSERT ON CUST_INFO FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT
SEQ_CUST_INFO.NEXTVAL INTO :NEW.ID
FROM
DUAL;
SELECT
SYSDATE INTO :NEW.INPUT_TIME
FROM
DUAL;
END;