Hi,
I am using Oracle 11g.
I am storing multiple values in a column separated by delimiter(#@#). I know it is wrong database design but since it is used for many years i can't do much about it.
I need to perform a search operation where i pass multiple values and i should get all the records if any one value match within the stored value. I read about regular expressions for such scenarios.
Can someone guide me how to proceed with this? Thanks in advance.
Thanks