1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

newsequentialid() incrementing

Discussion in 'SQL PL/SQL' started by prabhur, Apr 30, 2015.

  1. prabhur

    prabhur Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    I got id value with newsequentialid() like below

    3564A919-18EF-E411-83A1-D4AE52C8DF89
    3664A919-18EF-E411-83A1-D4AE52C8DF89
    3764A919-18EF-E411-83A1-D4AE52C8DF89

    first two digits are incrementing sequential.

    I what to increment 17 to 20 digits with hexadecimal values like below

    3564A919-18EF-E411-0100-0EC241552704
    3564A919-18EF-E411-0200-0EC241552704
    3564A919-18EF-E411-0300-0EC241552704
    3564A919-18EF-E411-0400-0EC241552704
    3564A919-18EF-E411-0500-0EC241552704
    3564A919-18EF-E411-0600-0EC241552704
    3564A919-18EF-E411-0700-0EC241552704
    3564A919-18EF-E411-0800-0EC241552704
    3564A919-18EF-E411-0900-0EC241552704
    3564A919-18EF-E411-0A00-0EC241552704
    3564A919-18EF-E411-0B00-0EC241552704
    3564A919-18EF-E411-0C00-0EC241552704
    3564A919-18EF-E411-0D00-0EC241552704
    3564A919-18EF-E411-0E00-0EC241552704
    3564A919-18EF-E411-0F00-0EC241552704
    3564A919-18EF-E411-1000-0EC241552704
    3564A919-18EF-E411-1100-0EC241552704
    3564A919-18EF-E411-1200-0EC241552704
    3564A919-18EF-E411-1300-0EC241552704
    3564A919-18EF-E411-1400-0EC241552704
    3564A919-18EF-E411-1500-0EC241552704
    3564A919-18EF-E411-1600-0EC241552704
    3564A919-18EF-E411-1700-0EC241552704
    3564A919-18EF-E411-1800-0EC241552704
    3564A919-18EF-E411-1900-0EC241552704
    3564A919-18EF-E411-1A00-0EC241552704
    3564A919-18EF-E411-1B00-0EC241552704
    3564A919-18EF-E411-1C00-0EC241552704
    3564A919-18EF-E411-1D00-0EC241552704
    3564A919-18EF-E411-1E00-0EC241552704
    3564A919-18EF-E411-1F00-0EC241552704
    3564A919-18EF-E411-2000-0EC241552704


    Help me to solve task

    With regards
    Prabhu
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    There is no such function in Oracle. There apparently is in SQL Server, but this is the wrong forum for that.