1 2 3 Previous Next 34 Replies Latest reply: Feb 22, 2013 8:07 AM by 980086 Go to original post RSS
      • 30. Re: number plan issue in pl/sql
        980086
        1---13F
        14--142F <-- one before next element
        143---14301F <-- next element, why not 14300F:because:I took 14301 as next numeric value after 143.if diff bet 2 consecutive number given is 1,then that will be included.
        14302---14302F
        14303----14303F
        14304---14305F
        14306----14306F
        14307----1431F
        1432---1432F <-- last element of group, why not 14321F:because 14321 is not present in the actual series.
        14321---14321F
        14322---14322F
        14323----14326F
        14327----14327F
        14328----144F
        145----146F
        147-----1F
        • 31. Re: number plan issue in pl/sql
          ascheffer
          1---13F
          14--142F <-- one before next element
          next actual numeric value is 143, difference between 14 and 143 is not 1, group ends before next numeric value
          143---14301F <-- next element, why not 14300F:because:I took 14301 as next numeric value after 143.if diff bet 2 consecutive number given is 1,then that will be included.
          next actual numeric value is 14301, difference between 143 and 14301 is not 1, group ends with next numeric value
          What's the difference with the previous case
          14302---14302F
          14303----14303F
          14304---14305F
          14306----14306F
          14307----1431F
          1432---1432F <-- last element of group, why not 14321F:because 14321 is not present in the actual series.
          next actual numeric value is 14322, difference between 1432 and 14302is not 1, group ends with current numeric value
          What's the difference with the previous two cases
          14321---14321F
          14322---14322F
          14323----14326F
          14327----14327F
          14328----144F
          145----146F
          147-----1F

          Edited by: ascheffer on Feb 5, 2013 4:06 PM
          • 32. Re: number plan issue in pl/sql
            980086
            sorry for confusing you all.
            *When there is a change in number of digits(143(3 digit),14301(5 digit)) the end number will be (nextnumber-1)F.
            **when no change in number of digits then [if (2nd number-1st number)=1 then series:-1st number---2nd number||F........if  (2nd number-1st number)>1 then series:-1st number---1st number||F] ....And all the number range should be present. Like here 14303 and 14306 is present.no 14304,14305.So one number range should be included as 14304---14305F.

            The correct combination:-
            1---13F
            14--142F
            143---14300F *
            14301--14301F
            14302---14302F
            14303----14303F **
            14304---14305F
            14306----14306F
            14307----1431F
            1432---14321F
            14322---14322F
            14323----14326F
            14327----14327F
            14328----144F
            145----146F
            147-----1F
            • 33. Re: number plan issue in pl/sql
              980086
              Please Help ...
              • 34. Re: number plan issue in pl/sql
                980086
                Hi Please can any one help me out....
                1 2 3 Previous Next