??????????????SEQUENCE?????У?
?????????б?temp_test?????
????create table TEMP_TEST
????(
????id number??
????nm varchar(10)??
????primary key(id)   //id?????????????????????????????
????)
????1??????????????TEMP_TEST_IDADD????????????1???????μ?1
????CREATE SEQUENCE TEMP_TEST_IDADD INCREMENT BY 1 START WITH 1;
????2?????temp_test???????????????
????CREATE OR REPLACE TRIGGER T_TEMP_TEST_IDADD
????BEFORE INSERT ON TEMP_TEST
????FOR EACH ROW
????BEGIN
????SELECT TEMP_TEST_IDADD.NEXTVAL INTO :NEW.ID FROM DUAL;
????END T_TEMP_TEST_IDADD;
????????Ч????
??????temp_test???????????????????????????
????insert into TEMP_TEST(nm)
????values('ss');
??????????￡?