SQL>
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>
SQL> SELECT isbn
2 FROM book
3 WHERE CONTAINS(description, 'website') > 3;
SELECT isbn
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
SQL>
SQL> drop table book;
Table dropped.
SQL>
|