Hi Experts,
DB version : Oracle 10g(10.2)
I am trying to solve a search problem related to Text Index. Following is my scenario.
CREATE TABLE MY_TABLE(ISBN VARCHAR2(100))
INSERT INTO MY_TABLE VALUES('123-45678')
INSERT INTO MY_TABLE VALUES('12345678')
What I need
If some one give 123-45678, then both the rows should return i.e. 123-45678 & 12345678.
If some one give 12345678, then both the rows should return i.e. 123-45678 & 12345678.
Is it possible to achieve through text index?
Any help will be highly appreciated.
Thanks in advance.