摘要:
首先建立序列:Create sequence user_id Increment by 1 Start with 1 Maxvalue 1.0E28 Minvalue 1 nocycle Cache 20 Noorder;然后建立触发器create or replace trigger AUTO_ID_ADDbefore insert on userinforeferencing old as old_valuenew as new_valuefor each rowbeginselect USER_ID.nextval into :new_value.id from dual;e... 阅读全文