--索引
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 ;
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 ;