Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    india
    Posts
    24

    Unanswered: auto increment number

    How to use next value of a table column if it is autoincrement number type.
    regards,
    Chary

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    define a sequence

    create sequence sq_mysequence increment .. minvalue .. maxvalue ...

    then

    select sq_mysequence.nextval from dual;

    within the insert statement
    insert into mytable (autoincrement, ...) values (sq_mysequence.nextval ...)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •