创建 Oracle 序列触发器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25660307/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Creating Oracle Sequence Trigger
提问by user1928388
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.
我正在尝试创建序列触发器，但在 SQL Developer 中执行触发器 create sql 时发生错误。我不明白，实际上一切看起来都很好。我在下面分享详细信息，请帮助我，谢谢。
My trigger sql:
我的触发器sql：
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;
/
And error description:
和错误描述：
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
回答by Darshan Lila
Try this:
尝试这个：
CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE INSERT ON ACCOUNTS
FOR EACH ROW
WHEN (new.ID IS NULL)
BEGIN
:new.ID := ACCOUNTS_SEQ.NEXTVAL;
END;
/
Your sequence should look like this:
您的序列应如下所示：
CREATE SEQUENCE ACCOUNTS_SEQ
START WITH 1
INCREMENT BY 1;
回答by user6159630
CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE INSERT ON ACCOUNTS
FOR EACH ROW
BEGIN
IF :new.ID IS NULL THEN
SELECT ACCOUNTS_SEQ.NEXTVAL
INTO :new.ID
FROM dual;
END IF;
END;
