1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to frame a query..

Discussion in 'Oracle' started by ashoo, Oct 3, 2007.

Thread Status:
Not open for further replies.
  1. ashoo

    ashoo New Member

    Joined:
    Oct 3, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi 2 ALL,

    I have got an 11 digit no to be generated in a table..
    11 digits are distributed as
    PPxxxxxxxxM --(Here PP are 10,11,12; xxxxxxxx ranges from 00000000 to 99999999 and the complicated part is the 11th digit which is the MOD 10 of all the 10 digits.)

    One way is to go ahead and create a sequence from 1000000000 to 1299999999 but how the MOD10 can be calculated for each number and to be concatenated as 11th digit for each number..
    what needs to be done if the intial digits(PPP) required is 100 apart from 10,11,12. :confused:
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
Thread Status:
Not open for further replies.

Share This Page