CREATE TRIGGER TIGER_ID_NUM BEFORE INSERT ON USER_INFO FOR EACH ROW WHEN (NEW.ID_NUM IS NULL)
BEGIN
SELECT SEQ_ID_NUM.nextval INTO: NEW.ID_NUM FROM dual;
END TIGER_ID_NUM ;
/INSERT INTO user_info VALUES (null, 'admin', '1', 'e10adc3949ba59abbe56e057f20f883e', '超级管理员', '0', '20150709112043', '20131008173414', '20131218145707', 'lisy', '20131218160814', null, null, 'B', 'B', null, null, null, null);
INSERT INTO user_info VALUES (null, 'input1', '1', 'e10adc3949ba59abbe56e057f20f883e', '录入员1', '0', '20140211152321', '20131009163540', '20131009164001', 'admin', '20131224153836', null, null, 'B', 'B', null, 'test3', null, null);
INSERT INTO user_info VALUES (null, 'xxj', '1', 'e10adc3949ba59abbe56e057f20f883e', '李进', '0', '20150617164831', '20150617160647', '20150617163951', 'xxj', '20150617163951', null, null, 'B', null, null, 'admin', null, null);
1 回答
- 1 回答
- 0 关注
- 2891 浏览
添加回答
举报
0/150
提交
取消