search for reserved word in Oracle Text

From: Ivan Chow <ichow2_at_hotmail.com>
Date: Thu, 17 Jun 2004 14:36:22 -0400
Message-ID: <BAY12-F49dPmvsQJoLG00069b3b@hotmail.com>

Hi,
Anyone has any idea how to query a reserved word in Oracle Text? I placed an escape character \ before the reserved word but it did not return the record.

TIA Ivan

SQL> insert into testtab values (1,'?');

1 row created.

SQL> commit;

Commit complete.

SQL> select text from testtab where contains(text, '\?')>0;

no rows selected

SQL> select text from testtab where contains(text, '{?}')>0;

no rows selected

---

Is your PC infected? Get a FREE online computer virus scan from McAfeeŽ Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jun 17 2004 - 14:21:24 CDT