*
The moose likes JDBC and the fly likes sql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sql query" Watch "sql query" New topic
Author

sql query

sumit malik
Greenhorn

Joined: Oct 31, 2001
Posts: 21
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!!
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

never mind, you've cross posted
It is generally good etiquette to post in the most appropriate forum, not in as many forums as possible to get answers
Jamie
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 565
I found this comprehensive link that perhaps should get put on javaranch:
How To Ask Questions The Smart Way
http://www.tuxedo.org/~esr/faqs/smart-questions.html

Check it out, Sumit Malik!


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.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

WOW! The guy that wrote that must be psychic, cause he read my mind! I'll keep that link handy for sure...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql query
 
Similar Threads
regarding MS access sql query
soundex problem
Searching words in VARCHAR2 & CLOB
Simple mdb connection Error
Searching words in VARCHAR2 & CLOB