locked
Auto increment in vb.net and oracle table RRS feed

  • Question

  • User-1578974752 posted

    How can I insert a new number inside table of the oracleDB. For next insertion increment by 1 like that it goes on [Just like Auto increment of column by placing it as bigint and increment by 1]

    when I tried as below

    cmd.CommandText = "Insert into inciden(number) values(id.nextval)"

    Sequence not exist message is showing.

    Tried as below also:

    SELECT TOP(1) NUMBER FROM incident BY 1 DESC

    but error

    Appreciate the Help

    Thursday, November 8, 2018 10:03 AM

Answers

All replies