ORACLE ×ÔÔö×ֶΣ¬Ð´µÄTRIGERÓÐÎÊÌâ

CREATE TRIGGER TRG_email
BEFORE INSERT  ON email
FOR EACH ROW
begin SELECT EMAIL_SEQUENCE.NEXTVAL
    INTO :NEW.emid
    from DUAL;
End ;


PL/SQL DEVELOPERÖÐÖ´ÐÐÁË£¬endÖ®ºó¾Í²»×ßÁË£¬Ò²²»ÌáʾÊÇ·ñ´´½¨³É¹¦

¿´ÏÂÃæµÄÌáʾ
SQL> CREATE TRIGGER TRG_email
  2  BEFORE INSERT  ON email
  3  FOR EACH ROW
  4  begin SELECT EMAIL_SEQUENCE.NEXTVAL
  5      INTO :NEW.emid
  6      from DUAL;
  7  End ;
  8 
  9 
10 
11  ;
12  ;
13  ;

---

CREATE TRIGGER TRG_email
BEFORE INSERT  ON email
FOR EACH ROW
begin SELECT EMAIL_SEQUENCE.NEXTVAL
    INTO :NEW.emid
    from DUAL;
End TRG_email;

---

SQL>
SQL> CREATE TRIGGER TRG_email
  2  BEFORE INSERT  ON email
  3  FOR EACH ROW
  4  begin SELECT EMAIL_SEQUENCE.NEXTVAL
  5      INTO :NEW.emid
  6      from DUAL;
  7  End TRG_email;
  8 
  9 
10 
11 
12 
12 
12 

Ϊʲôû·´Ó¦£¬Ò»Ö±ÕâÑù×ßÏÂÈ