ORACLE自增,关联删除

--索引

CREATE SEQUENCE S_TABLENAME INCREMENT BY 1 START WITH 1 NOCYCLE CACHE 20 NOORDER;.

 

--触发器
CREATE OR REPLACE TRIGGER T_TABLENAME 
    BEFORE INSERT ON TABLENAME FOR EACH ROW
BEGIN
    SELECT S_TABLENAME .NEXTVAL INTO :NEW.ID FROM DUAL;
END;

 

---关联删除

CREATE OR REPLACE TRIGGER wcm_news_upload_clean_t
AFTER DELETE ON wcm_news
FOR EACH ROW
BEGIN
   delete from wcm_upload where newsid=:OLD.id;
END ;