Re: OracleText: Search for exact string match

  • From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 17 Jun 2004 23:38:15 +0200

Hi Susan,

if looking for *exact match*, what about:

select textid, text from text_table 
where text = 'Lethal Weapon';

regards

Jaromir D.B. Nemec

----- Original Message ----- 
From: "susan lam" <susanzlam@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, June 17, 2004 2:11 PM
Subject: RE: OracleText: Search for exact string match

> It returned the exact match I was looking for.


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: