Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    14

    Unanswered: Sybase similar feature like Oracle Sequence

    Dear all,

    In oracle, we can defined Sequence and then use the following to refer to the sequence.

    select testseq.nextval into test from dual;

    Is there any similar feature in Sybase 12 ?

    Thanks in advance.

    Regards,

    Thomas HO

  2. #2
    Join Date
    Jun 2003
    Posts
    140
    You can use identity column to generate the sequential values , use @@identity global variable to retrieve the last value that you inserted
    you can store the value in a variable and manipulate it

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    For more complex type of sequences, you can use Abstract Data Type according with the Java module too

Posting Permissions

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