Re: ConText CONTAINS in PL/SQL

From: Rüdiger J. Schulz <r.schulz_at_berlin.de>
Date: Fri, 15 Jan 1999 10:16:05 +0000
Message-ID: <369F1564.68062CE9@berlin.de>

try the following sql-statement for a one-step-query:

    select test1, test2 from tablename where CONTAINS(test1, 'searchvalue') > 0;

(here is test1 the column on which the context-policy runs)

Richard Murphy schrieb:

> Anyone know how to access the ConText CONTAINS function from within a
> PL/SQL block? Most likely the only way is a two step query, but would
> prefer a one step query.
>
> Thanks, R.

--
b e r l i n . d e - d e r o n l i n e d i e n s t d e r s t a d t

---

Primus-Online Berlin-Brandenburg GmbH & Co. KG debis Haus am Potsdamer Platz
10875 Berlin

Rüdiger J. Schulz
Technik

tel: +49 (30) 2554-1497
fax: +49 (30) 2554-3725
email: r.schulz_at_berlin.de
homepage: http://www.berlin.de Received on Fri Jan 15 1999 - 04:16:05 CST