0 : CONTAINS « Char Functions « Oracle PL / SQL'> 0 : CONTAINS « Char Functions « Oracle PL / SQL'>

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






  1. Oracle PL / SQL
  2. Char Functions
  3. CONTAINS

CONTAINS(description, '10g near oracle') > 0

  

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.








Related examples in the same category

1.CONTAINS(description, 'website') > 3
2.Proximity searches with contains
3.Test case-insensitivity with a simple mixed-case query