create sequence lg_sequence
start with 1
increment by 1
order //保证每个序列值都比先前的大, ********在并行服务中有用
nocycle; //防止循环又回到初始值
NOCACHE NOORDER;
start with 1
increment by 1
order //保证每个序列值都比先前的大, ********在并行服务中有用
nocycle; //防止循环又回到初始值
NOCACHE NOORDER;
调试欢乐多
DROP SEQUENCE SEQ_DIC_FIELD;
CREATE SEQUENCE SEQ_DIC_FIELD
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999999999999
NOCYCLE
NOCACHE
ORDER;
COMMIT;--数据库表字段字典自动创建编号
CREATE OR REPLACE TRIGGER TRG_ADD_DIC_FIELD
BEFORE INSERT ON T_DIC_FIELD
FOR EACH ROW
BEGIN
SELECT SEQ_DIC_FIELD.NEXTVAL INTO :NEW.SN FROM DUAL;
END TRG_ADD_DIC_FIELD; 照这个自己改一下就可以用了。
行号= 2 列号= 27 错误文本= PLS-00049: bad bind variable 'NEW.SN'
出现编译错误阿我希望表GDMTEST中的ID字段自动记数,我是这样写的:DROP SEQUENCE SEQ_DIC_FIELD;
CREATE SEQUENCE ID
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999999999999
NOCYCLE
NOCACHE
ORDER;
COMMIT;CREATE OR REPLACE TRIGGER TRG_ADD_DIC_FIELD
BEFORE INSERT ON GDMTEST
FOR EACH ROW
BEGIN
SELECT ID.NEXTVAL INTO :NEW.SN FROM DUAL;
END TRG_ADD_DIC_FIELD;
这样有什么不对吗??谢谢
错误代码
行号= 2 列号= 27 错误文本= PLS-00049: bad bind variable 'NEW.SN'
出现编译错误阿