title: Creating Oracle Sequence Trigger
body: <p>I'm trying create seuqunce trigger but error occurs when I executing the trigger create sql in SQL Developer. I don't understand, actually everything looks fine. I share the details below, please help me, thanks.</p>
  
  <p>My trigger sql:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE OR REPLACE TRIGGER "TRIGGER1" BEFORE INSERT ON ACCOUNTS
  FOR EACH ROW
   WHEN (new."ID" IS NULL) 
  BEGIN
    SELECT ACCOUNTS_SEQ.NEXTVAL 
    INTO :new."ID" 
    FROM dual;
  END;
  /
  </code></pre>
  
  
  
  <p>And error description:</p>
  
  <pre><code>Error starting at line : 5 in command -
  CREATE OR REPLACE TRIGGER "TRIGGER1" BEFORE INSERT ON ACCOUNTS
  FOR EACH ROW
   WHEN (new."ID" IS NULL) 
  BEGIN
    SELECT ACCOUNTS_SEQ.NEXTVAL 
    INTO :new."ID" 
    FROM dual
  Error report -
  SQL Command: trıgger "TRIGGER1"
  Failed: Warning: completed with warning
  
  Error starting at line : 12 in command -
  END
  Error report -
  Unknown Command
  </code></pre>