search engine returning links to threads that do NOT contain the search term [message #448941] |
Thu, 25 March 2010 22:49 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
I have just done a search for 'count_query' and the first link is Quote:Forum: Forms «» Posted on: Thu, 18 March 2010 23:39 «» By: Littlefoot
Re: Running Oracle Report Through Form6i and validating between two dates
What is the POF_NPOF column's datatype? You said that it contains "P" and "N" only. What is the result of the following query:select pof_npof, length(pof_npof), count(*) cnt from this_table group by pof_npof, length(pof_npof); at
http://www.orafaq.com/forum/m/447912/67467/?srch=count_query#msg_447912
But this thread does NOT contain the search term 'count_query'. Nor do the next three threads.
If I use the 'site-level search engine' it appears to be working okay.
Is there documentation on using the search facility? I know I can't search for numbers but is 'under_score' a special character for character substitution or some other thing?
David
|
|
|
Re: search engine returning links to threads that do NOT contain the search term [message #448982 is a reply to message #448941] |
Fri, 26 March 2010 02:18 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
djmartin wrote on Fri, 26 March 2010 04:49I have just done a search for 'count_query' and the first link is Quote:Forum: Forms «» Posted on: Thu, 18 March 2010 23:39 «» By: Littlefoot
Re: Running Oracle Report Through Form6i and validating between two dates
What is ...
I'm sorry, I'll make sure to add "count_query" to all my future posts
You are right, David - I noticed the same behaviour. For example, sometimes people ask what TNS_ADMIN system variable is so I search for one of my messages where I explained how to use it, in order to post a link to that very message. Searching for "TNS_ADMIN" filtered by "me" returns different messages but never the one I'm looking for.
However, if I search for "lengthy" (it was a lengthy answer") filtered by "me" finds it.
Is it something with the way message texts are indexed, or what?
|
|
|
|
|