MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??

On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <mtek@mtekusa.com>
wrote:

>
>MySQL has this function, was wondering if this can be done with
>Oracle.
>
>Basically a query which uses the LIKE method, but is able to rank the
>results in relevance, which ones match the most to the fewest??

You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA

On Aug 26, 2:50 pm, sybra...@hccnet.nl wrote:
> On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m...@mtekusa.com>
> wrote:
>
>
>
> >MySQL has this function, was wondering if this can be done with
> >Oracle.
>
> >Basically a query which uses the LIKE method, but is able to rank the
> >results in relevance, which ones match the most to the fewest??
>
> You shouldn't assume any knowledge of MySQL in this forum.
> You also should stop treating this forum and
> news:comp.databases.oracle.server as a replacement for reading the
> official Oracle documentation and as a free Oracle course.
> You should post an example of the results of the LIKE function in
> MySQL.
> However, above all, you should stop being a bore!!!
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Seems like your wonderful personality just follows you everywhere. Go
play in the middle of the expressway with the rest of your kind.

On Aug 26, 1:01*pm, Mtek <m...@mtekusa.com> wrote:
> On Aug 26, 2:50 pm, sybra...@hccnet.nl wrote:
>
>
>
>
>
> > On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m...@mtekusa.com>
> > wrote:
>
> > >MySQL has this function, was wondering if this can be done with
> > >Oracle.
>
> > >Basically a query which uses the LIKE method, but is able to rank the
> > >results in relevance, which ones match the most to the fewest??
>
> > You shouldn't assume any knowledge of MySQL in this forum.
> > You also should stop treating this forum and
> > news:comp.databases.oracle.server as a replacement for reading the
> > official Oracle documentation and as a free Oracle course.
> > You should post an example of the results of the LIKE function in
> > MySQL.
> > However, above all, you should stop being a bore!!!
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Seems like your wonderful personality just follows you everywhere. *Go
> play in the middle of the expressway with the rest of your kind.

You might try going to http://tahiti.oracle.com and typing in:
oracle text

You shouldn't assume any knowledge of MySQL in this forum. You also
should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course. You should
post an example of the results of the LIKE function in MySQL.

However, above all, you should stop being a bore!!!

Apologies to Sybrand for any copyright violation.

jg
--
@home.com is bogus.
Who's accessing your database? http://www.signonsandiego.com/uniont..._1b26scam.html

On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <mtek@mtekusa.com>
wrote:

>
>Seems like your wonderful personality just follows you everywhere. Go
>play in the middle of the expressway with the rest of your kind.

How come types like you, refusing to read, are always so experienced
in flaming away. Does it have to do with IQ?
Or are you an impersonation of 'Sideshow Bob' or 'Krusty the Clown'?

--
Sybrand Bakker
Senior Oracle DBA

Mtek wrote:
> MySQL has this function, was wondering if this can be done with
> Oracle.
>
> Basically a query which uses the LIKE method, but is able to rank the
> results in relevance, which ones match the most to the fewest??

With apologies to Sybrand Bakker.

You should not assume any knowledge of MySQL in this forum.

Please do not use these forums as a replacement for Reading
The Fine Manuals available free from Oracle.

This may amaze you but we have been very successful for 20+
years solving business problems with Oracle. Thus it is
reasonable to conclude that the product contains the necessary
functionality.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

<sybrandb@hccnet.nl> wrote in message
news:k0u8b41s0hk8etc9h9ukecpa2u98irnf9q@4ax.com...
> On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <mtek@mtekusa.com>
> wrote:
>
>>
>>Seems like your wonderful personality just follows you everywhere. Go
>>play in the middle of the expressway with the rest of your kind.
>
> How come types like you, refusing to read, are always so experienced
> in flaming away. Does it have to do with IQ?
> Or are you an impersonation of 'Sideshow Bob' or 'Krusty the Clown'?
>
> --
> Sybrand Bakker
> Senior Oracle DBA
I must say Sybrand I didn't know you were a Simpsons fan.
Bravo.
Jim

On Tue, 26 Aug 2008 23:01:14 GMT, "gym dot scuba dot kennedy at gmail"
<kennedyii@verizon.net> wrote:

>
><sybrandb@hccnet.nl> wrote in message
>news:k0u8b41s0hk8etc9h9ukecpa2u98irnf9q@4ax.com.. .
>> On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <mtek@mtekusa.com>
>> wrote:
>>
>>>
>>>Seems like your wonderful personality just follows you everywhere. Go
>>>play in the middle of the expressway with the rest of your kind.
>>
>> How come types like you, refusing to read, are always so experienced
>> in flaming away. Does it have to do with IQ?
>> Or are you an impersonation of 'Sideshow Bob' or 'Krusty the Clown'?
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>I must say Sybrand I didn't know you were a Simpsons fan.
>Bravo.
>Jim
>
I am a Simpsons fan since a few months. It is airing on 'Comedy
Central', they just reached season 5, I believe.
I got hooked by the tune, which is a marvel, very much resembling
Bernsteins West Side Story. And of course the schoolboard gag, and the
couch gag.

Yesterday it was Sideshow Bob time, Sideshow Bob being released from
prison on parole, trying to murder Bart immediately.
I already knew Sideshow Bob gets his voice from Kelsey Grammer, the
weird psychiater in 'Cheers' and 'Frasier'.

--
Sybrand Bakker
Senior Oracle DBA

On Aug 26, 10:41*pm, sybra...@hccnet.nl wrote:
> On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <m...@mtekusa.com>
> wrote:
>
>
>
> >Seems like your wonderful personality just follows you everywhere. *Go
> >play in the middle of the expressway with the rest of your kind.
>
> How come types like you, refusing to read, are always so experienced
> in flaming away. Does it have to do with IQ?
> Or are you an impersonation of 'Sideshow Bob' or 'Krusty the Clown'?
>
> --
> Sybrand Bakker
> Senior Oracle DBA


I am so grateful that I don't have to work with you or work with
people like you Sybrand.

A while back it was asked why activity in this group had dropped off
so much over recent years.

http://groups.google.co.uk/group/com...er/about?hl=en

The caustic and unfunny comments and insults from you Sybrand Bakker
and you Daniel Morgan are the sole reason for this groups continuing
demise.

MTek I suggest you post your queries to oracle-l from now on. It is a
mediated forum and the on-going poster vetting process immediately
excludes social misfits and their antisocial comments. The crowd that
lurk in oracle-l are there to help or seek help.

Barry

On Wed, 27 Aug 2008 05:11:45 -0700 (PDT), Barry Bulsara
<bbulsara23@hotmail.com> wrote:

>I am so grateful that I don't have to work with you or work with
>people like you Sybrand.
>
>A while back it was asked why activity in this group had dropped off
>so much over recent years.
>
>http://groups.google.co.uk/group/com...er/about?hl=en
>
>The caustic and unfunny comments and insults from you Sybrand Bakker
>and you Daniel Morgan are the sole reason for this groups continuing
>demise.

Actually, both Daniel Morgan and myself are around here for at least
10 years.
The link you posted actually demonstrates exactly *nothing*.
Not surprisingly, as you only contributed flames to this forum.
Heck, the demise might be caused by you, 'Mr.' Bullshit.

I strongly suggest you discontinue lurking and dump your vitriolic
comments somewhere else.

Thank you!

--
Sybrand Bakker
Senior Oracle DBA