sql - How to create an Inverted Index on a table using Oracle -


I have a table named book with ISBN, title and description. I am trying to create the Inverted Index using this command on this table: 

  Book on my index (details) INDEXTYPE is CTXSYS.CONTEXT;   
 And I'm trying to query it with the query below:  
  SELECT score (1), contains the title WHERE from Book B ( B. Description, 'Hucklebury Finn', 1) & gt; Order according to 0 points; (1) DESC;   
 Every time I run this query, although no rows are selected, the query  
  SELECT title, book from the description where Description = 'Huckleberry Finn';   
 Returns:  
  Title Description ------------------------- ----------- 'Huckleberry', 'Huckleberry Finn'. I'm not sure what is wrong with my questions, this is the first time I've ever tried Inverted So to make an index, so if someone can tell me what is wrong in my query or there is another way to do this, I would appreciate it.  
 itemproc = "text"> 
 have you synced your index? In new versions, you can create your index so that it is updated to a committed Otherwise, you can count on a manual sync operation.  
 It is not possible to synchronize the index within a transaction.   Create search index_idx on ctx_demo ( Text) index type ctxsys.context parameter ('sync (on command)') /

Comments

Post a Comment