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

1. Oracle PL/SQL Tutorial
2. Character String Functions
3. CONTAINS

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.