Finding Pattern matching numbers in pl/sql
766896Apr 18 2010 — edited Apr 18 2010Hi,
I am trying to write a pl/sql script where i need to check pattern matching numbers.I tried my best but i am unable to reach any solution.Can anyone provide the logic for below.My database is oracle 10g and i will put this logic in a procedure.
a)First check to see if all last 4 numbers on line range are same(i.e 6546784444, 7654789999).
b)if above fails then check where 2 of numbers are same from last 4 digits(i.e. 5654323344, 79087652211)
c)if above 2 fails then check for pattern where 3 of numbers in line are same in last 4 digits.(i.e 7654567444, 7689045557).
i am trying to write the logic for above. Please post your reply if anyone knows.