Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Max value for sequence table

    Hi,
    How do I determine the max value of a Sequence Table in a database instance?
    Regards

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking



    If you refer to "max value of a sequence" then query {ALL|DBA|USER}_SEQUENCES
    Else you need to query the particular table:
    Code:
    SELECT MAX(theSequence) FROM MYTABLE;


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Or, if your question regards maximum possible value for a sequence, it is 10E27 on Oracle 10g.

    Whichever it is, perhaps you'd like to read something more about the way sequence is to be created; you'll find several links there for further reading.

Posting Permissions

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