extracting characters from a string
hi gurus,
i want to extract the first, third, fifth, seventh... characters from a string,
not extract characters from a subset of characters in a select query in oracle 9i database.
for example (1) :
suppose a string like this 'ABCDEFGHIJ' is there i wnat 'ACEGI' from the source string
and the source can be any valid string i have just given here a example.
example(2) from 'kalpataru' to klatau'
please guide me to do this