Cannot insert values in sequence

Question

CREATE SEQUENCE CountBy1
    START WITH 1
    INCREMENT BY 1
    MINVALUE 0;

CREATE TABLE TEST_SEQ (ID INT, NAME VARCHAR(200));

INSERT INTO TEST_SEQ values (NEXT VALUE FOR CountBy1,'Manoj Pandey');

shows this error

SQL Error: ORA-00917: missing comma

On docs.oracle.com/cd/B12037_01/server.101/b10759/… I don't see NEXT VALUE FOR as a possible syntax. — Barmar
– Barmar, Commented Dec 24, 2013 at 8:34
Trivial syntax error arising from failure to read the documentation. — APC
– APC, Commented Dec 24, 2013 at 8:38

RGO · Accepted Answer · 2013-12-24 08:33:59Z

4

Try this:

INSERT INTO TEST_SEQ values (CountBy1.NEXTVAL,'Manoj Pandey');

answered Dec 24, 2013 at 8:33

RGO

4,7774 gold badges30 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vishal Suthar · Accepted Answer · 2013-12-24 08:38:23Z

1

To retrieve the next value in the sequence order, you need to use nextval.

INSERT INTO TEST_SEQ values (CountBy1.nextval,'Manoj Pandey');

The ID field would be assigned the next number from the TEST_SEQ sequence.

Refer this for more info: SEQUENCE EXAMPLE

answered Dec 24, 2013 at 8:38

Vishal Suthar

17.2k4 gold badges64 silver badges109 bronze badges

Collectives™ on Stack Overflow

Cannot insert values in sequence

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related