PL/SQL Getting a list of sequence values
Posted on 2013-08-29
I am looking for a way to get a list of data based on what a user enters.
User Enters: A1001
I would like to get all the numbers that are in sequence (A1001, A1002, & A1003) using the entered value as the starting point.
Also, is it possible to get the same list(A1001, A1002, & A1003) if the user entered A1002 instead?
Thanks in advance.