Code Listing 3: Querying returns $mice search result

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

This query now returns two rows:

 SCORE(1)TITLE                     GENRE
 ------- -----------------------   ---------------
 5       My Mouse Won't Work Blues COMPUTER ENGINEER         
 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