oracle insertÓï¾ä:ÐòÁÐ(ºÅ)²»´æÔÚ

ÓÃselect * from user_Sequence where sequence_name = 'Sequence_userid'²éѯÊÇ´æÔÚµÄ

ÓÃinsert into ST_USER VALUES(Sequence_userid.nextval,'mark','mark','0')³öÏÖ:
        ERROR λÓÚµÚ 1 ÐÐ:
        ORA-02289: ÐòÁУ¨ºÅ£©²»´æÔÚ

---

SQL code:
SQL> SELECT SEQUENCE_NAME from USER_SEQUENCES;

SEQUENCE_NAME
------------------------------
ABCD_SEQ

SQL> insert into t5(id) values(ABCD_SEQ.NEXTVAL);

ÒÑ´´½¨ 1 ÐС£

SQL>

---

ÒýÓÃ

ÓÃselect * from user_Sequence where sequence_name = 'Sequence_userid'²éѯÊÇ´æÔÚµÄ

ÓÃinsert into ST_USER VALUES(Sequence_userid.nextval,'mark','mark','0')³öÏÖ:
        ERROR λÓÚµÚ 1 ÐÐ:
        ORA-02289: ÐòÁУ¨ºÅ£©²»´æÔÚ

ÄãµÄST_USER±íÖÐÖ»ÓÐ4ÁÐÂ𣿣¿Èç¹û²»Ö¹4ÁеĻ°£¬ÇëÌîдËùÓеÄÁС£

---

È·¶¨Ö»ÓÐËÄÁУ¬ÇÒSELECT SEQUENCE_NAME from USER_SEQUENCES²éѯÊÇ´æÔÚµÄ

---

°ÑÄãµÄst_user±íµÄ½á¹¹Åª³öÀ´¿´¿´¡£
¿´Äã²åÈëµÄÁÐÀàÐÍÊÇ·ñ¶¼ÕýÈ·¡£

insert into st_user values(SEQUENCE_USERID.NEXTVAL,'mark','mark','0');
ÕâÑùÊÔÊÔ£¨ËäÈ»ºÍÄãµÄsqlÓï¾äÒ»Ñù£©¡£

---

Ë«ÒýºÅ""ÈǵĻö¡£
ÎÞ""ʱ£¬ORACLE¶ÔÏóÃû¶¼ÊÇ´ó