Code Listing 2: Running text query on text index

SELECT score(1), title, genre
FROM songs
WHERE CONTAINS(title, 'mice', 1) > 0;

This query should return a single row:

 SCORE(1)TITLE                     GENRE
 ------- -----------------------   -----
 5       The Preble Mice Go Squeak CHILD

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy