Oracle用觸發器實現自增長列:
比如表名:tab,主鍵為:id
1. 增加壹個序列號: ? create sequence seq_tab
2. 增加壹個觸發器,如果是insert,則取序列號值,賦予主鍵列
CREATE?OR?REPLACE?TRIGGER?TRI_tabBEFORE?INSERT?ONtabFOR?EACH?ROW
DECLARE
--?LOCAL?VARIABLES?HERE?
BEGIN
IF?:NEW.id?IS?NULL?THEN
SELECT?SEQ_tab.NEXTVAL?INTO?:NEW.id?FROM?DUAL;
END?IF;
END?TRI_tab;