1 2 3 Previous Next 34 Replies Latest reply on Feb 22, 2013 2:07 PM by 980086 Go to original post
• ###### 30. Re: number plan issue in pl/sql
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
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
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