hi ...i'm using oracle's soundex function in my sql query , but the problem is that sometimes it works fine but sometimes it returns rows which i dont want ..and there is no excat pattern matching...of words.. for eg if i search for "vasant vihar" it gives me all the words starting with "v" but ideally it should giv only terms related with "vasant" i want to use more refined search.. pls hurry up folks!!
If you are having Oracle specific problems (PL/SQL, Oracle extensions/products) and such, which it sounds like, there is a new forum here dedicated to Oracle. You might want to try there so the Oracle gurus could help. Jamie
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.