oracle的分號和斜杠/

標籤：

;是執行語句必須的
/是執行語句塊必須的

比如執行一個觸發器

CREATE OR REPLACE TRIGGER "TRG_1" BEFORE INSERT ON "CATEGORY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW ENABLE
DECLARE 
v_newVal NUMBER(12) := 0;
v_incval NUMBER(12) := 0;
BEGIN
  IF INSERTING AND :new.catid IS NULL THEN
    SELECT  catid_seq.NEXTVAL INTO v_newVal FROM DUAL;
    IF v_newVal = 1 THEN 
      SELECT NVL(max(catid),0) INTO v_newVal FROM category;
      v_newVal := v_newVal + 1;
      LOOP
           EXIT WHEN v_incval>=v_newVal;
           SELECT catid_seq.nextval INTO v_incval FROM dual;
      END LOOP;
    END IF;
   :new.catid := v_newVal;
  END IF;
END;
/
CREATE OR REPLACE TRIGGER "TRG_1" BEFORE INSERT ON "CATEGORY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW ENABLE
DECLARE 
v_newVal NUMBER(12) := 0;
v_incval NUMBER(12) := 0;
BEGIN
  IF INSERTING AND :new.catid IS NULL THEN
    SELECT  catid_seq.NEXTVAL INTO v_newVal FROM DUAL;
    IF v_newVal = 1 THEN 
      SELECT NVL(max(catid),0) INTO v_newVal FROM category;
      v_newVal := v_newVal + 1;
      LOOP
           EXIT WHEN v_incval>=v_newVal;
           SELECT catid_seq.nextval INTO v_incval FROM dual;
      END LOOP;
    END IF;
   :new.catid := v_newVal;
  END IF;
END;
/

oracle的分號和斜杠/