0 : CONTAINS « Character String Functions « Oracle PL/SQL Tutorial'> 0 : CONTAINS « Character String Functions « Oracle PL/SQL Tutorial'>

CONTAINS(description, '10g near oracle') > 0 : CONTAINS « Character String Functions « Oracle PL/SQL Tutorial






SQL> CREATE TABLE book (
  2     id   NUMBER (10) PRIMARY KEY,
  3     isbn             VARCHAR2(10),
  4     description      VARCHAR2(500));

Table created.

SQL>
SQL> INSERT INTO book(id,isbn,description)VALUES (1,'3', 'The essential PL/SQL.');

1 row created.

SQL> SELECT isbn
  2  FROM book
  3  WHERE CONTAINS(description, '10g near oracle') > 0;
SELECT isbn
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed


SQL>
SQL>
SQL> drop table book;

Table dropped.








11.21.CONTAINS
11.21.1.CONTAINS(description, '10g near oracle') > 0
11.21.2.CONTAINS(description, 'website') > 3
11.21.3.Proximity searches with contains