LIKE Question

On Aug 26, 1:01 pm, Mtek <m....DeleteThis@mtekusa.com> wrote:
> On Aug 26, 2:50 pm, sybra....DeleteThis@hccnet.nl wrote:
>
>
>
>
>
> > On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m....DeleteThis@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/uniontrib/20080826/news_1b26scam.html
 >> Stay informed about: LIKE Question 

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 RemoveThis @x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 >> Stay informed about: LIKE Question 

On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <mtek RemoveThis @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
 >> Stay informed about: LIKE Question 

On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <mtek.RemoveThis@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
 >> Stay informed about: LIKE Question 

<sybrandb.RemoveThis@hccnet.nl> wrote in message
news:k0u8b41s0hk8etc9h9ukecpa2u98irnf9q@4ax.com...
> On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <mtek.RemoveThis@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
 >> Stay informed about: LIKE Question 

On Aug 26, 10:41 pm, sybra....TakeThisOut@hccnet.nl wrote:
> On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <m....TakeThisOut@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/comp.databases.oracle.server/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
 >> Stay informed about: LIKE Question 

On Aug 27, 1:20 pm, sybra....DeleteThis@hccnet.nl wrote:
> On Wed, 27 Aug 2008 05:11:45 -0700 (PDT), Barry Bulsara
>
> <bbulsar....DeleteThis@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/comp.databases.oracle.server/about?h...
>
> >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

Thank you for your eliquant reply and prompt demonstration of my
point.
Good day
Barry
 >> Stay informed about: LIKE Question 

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

>
><sybrandb.DeleteThis@hccnet.nl> wrote in message
>news:k0u8b41s0hk8etc9h9ukecpa2u98irnf9q@4ax.com...
>> On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <mtek.DeleteThis@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
 >> Stay informed about: LIKE Question 

On Wed, 27 Aug 2008 05:11:45 -0700 (PDT), Barry Bulsara
<bbulsara23 RemoveThis @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/comp.databases.oracle.server/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
 >> Stay informed about: LIKE Question 

On Aug 27, 5:11 am, Barry Bulsara <bbulsar....DeleteThis@hotmail.com> wrote:
> On Aug 26, 10:41 pm, sybra....DeleteThis@hccnet.nl wrote:
>
> > On Tue, 26 Aug 2008 13:01:33 -0700 (PDT), Mtek <m....DeleteThis@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/comp.databases.oracle.server/about?h...
>
> The caustic and unfunny comments and insults from you Sybrand Bakker
> and you Daniel Morgan are the sole reason for this groups continuing
> demise.

I don't think that is it at all. Looking back on the high-volume
points in that post, I see several posters that have gone on to host
their own fora. Maybe that and google are the real reason. Not to
mention all the other groups on google, and the newer wave of things I
suppose Eddie Awad will be talking about those things
http://awads.net/wp/2008/07/31/simple-tips-to-quickly-find-answers-to-...r-oracl

>
> 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.

Oracle-l is a good resource, but it has issues, too. For example,
some people don't realize that while they are free to proselytize
religion and attempt to control behavior, others are free to be
offended by it. And the mailing list paradigm doesn't exactly support
thoughtful reasoned discourse, much more so even than usenet. So it
_has_ to have worse netcops than here, you call it vetting, I call it
too much moderation. Don't tell a joke, you might be kicked off! And
they decided to make it like it is: http://www.freelists.org/archives/oracle-l/10-2005/msg01180.html

I say, don't be afraid of your freedom!

jg
--
@home.com is bogus.
“It was pretty eye-popping, some of the stuff we were seeing. We
couldn't believe it.” - Sheila Bair, chairwoman of the Federal Deposit
Insurance Corp., about how the FDIC bought a database in 2006 to study
the industry's loan performance. Or is that charwoman?
 >> Stay informed about: LIKE Question