/*
-- 序列号
CREATE SEQUENCE seq_supplierno
increment by 1 -- 每次递增1
start with 1 -- 从1开始
nomaxvalue -- 没有最大值
minvalue 1 -- 最小值=1
NOCYCLE;
*/
-- 触发器.
--DROP TRIGGER tr_supplier_seqno
CREATE OR REPLACE TRIGGER tr_supplier_seqno
BEFORE INSERT ON TAB_SUPPLIER
FOR EACH ROW
BEGIN
SELECT
TO_CHAR(sysdate, 'YYYYMMDD')||'-'||:new.SPECIALCODE||'-'||TRIM(TO_CHAR(seq_supplierno.nextval, '001')) INTO :new.DOCUMENTNO
FROM
dual;
END;
-- 序列号
CREATE SEQUENCE seq_supplierno
increment by 1 -- 每次递增1
start with 1 -- 从1开始
nomaxvalue -- 没有最大值
minvalue 1 -- 最小值=1
NOCYCLE;
*/
-- 触发器.
--DROP TRIGGER tr_supplier_seqno
CREATE OR REPLACE TRIGGER tr_supplier_seqno
BEFORE INSERT ON TAB_SUPPLIER
FOR EACH ROW
BEGIN
SELECT
TO_CHAR(sysdate, 'YYYYMMDD')||'-'||:new.SPECIALCODE||'-'||TRIM(TO_CHAR(seq_supplierno.nextval, '001')) INTO :new.DOCUMENTNO
FROM
dual;
END;