Home » Server Options » Text & interMedia » Oracle Text "starts with" search
Oracle Text "starts with" search [message #212758] Mon, 08 January 2007 03:44 Go to next message
SaraC
Messages: 81
Registered: August 2005
Member
Can Oracle Text implement a "starts with" search?

ie.

search term heart would return all rows from the indexed table which start with heart - and not items that have "heart" somewhere in the text?

Trying to see if it could implement both a "starts with" and "contains" search - know it can do contains i.e. search anywhere in string for search term but couldnt find anywhere info if it can do string starts with i.e. search term only at the start of the string.

Thanks for any help.
S

Report message to a moderator

Re: Oracle Text "starts with" search [message #212842 is a reply to message #212758] Mon, 08 January 2007 09:07 Go to previous message
SaraC
Messages: 81
Registered: August 2005
Member
Thanks to those who read the post.

Going to implement the "starts with" search using simple LIKE % search and "contains" search using Oracle Text

Report message to a moderator

Previous Topic: Cannot create text index in partition table on Oracle 10g
Next Topic: How to index embedded documents
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 16:16:04 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.