小弟刚接触oracle10g,
求各位大大帮帮我,谢了!CREATE OR REPLACE TRIGGER user_tg
BEFORE INSERT ON users
FOR EACH ROW
BEGIN
SELECT user_sequence.NEXTVAL INTO :NEW.userid FROM DUAL;
END user_tg;按回车后怎么没有执行,而是出现7 (行数)。
求各位大大帮帮我,谢了!CREATE OR REPLACE TRIGGER user_tg
BEFORE INSERT ON users
FOR EACH ROW
BEGIN
SELECT user_sequence.NEXTVAL INTO :NEW.userid FROM DUAL;
END user_tg;按回车后怎么没有执行,而是出现7 (行数)。
BEFORE INSERT ON users
FOR EACH ROW
BEGIN
SELECT user_sequence.NEXTVAL INTO :NEW.userid FROM DUAL;
END user_tg;
这个直接执行没问题,测试也是正常的,
敲回车执行,你输入;就可以啦。、
在SQL窗口里执行,SELECT user_sequence.NEXTVAL INTO :NEW.userid FROM DUAL;
这里已经出现一个分号了。
BEFORE INSERT ON users
FOR EACH ROW
BEGIN
SELECT user_sequence.NEXTVAL INTO :NEW.userid FROM DUAL;
END user_tg;
/
--输入斜杠,表示输入完成并执行编译