2003

W2: Put your answer to this working group assignment 
in a .txt file.  (I do not want to see the sql file. Just the statements 
and your words in a .txt file.) 

Put the text file in you web space and mail me a "url" to the file. 
(*----------------------------------------------------------------*)

The Oracle documentation is on our web page and also at these references.
(They are: http://otn.oracle.com/products/text/ or 
http://otn.oracl.com/forums/text.html or others found on google.com)

(1) Answer the following questions: 
	(a) what are 'preferences'? 
	(b) what is a 'datastore'?  
	(c) when can I use the 'contains' operator?
	(d) does this index use a 'stopwords' list? If not, write the statement that
		would include a stopword list when the index is created?

(2) Do the following steps. My example is below.
	(a) Create a table. 
	(b) Populate the table by inserting a file that is in your web space.
	(c) Create a "context" type index. 
	(d) Perform a "select" using your index such that the statement returns a hit. 

(These are my examples.) 

exec ctx_ddl.create_preference('mygrpurl','URL_DATASTORE');

drop index mygrpindex;
drop table mygrptable;
create table mygrptable(id number primary key, docs varchar2(2000));

   
(Move a .txt file into your /html directory.)


insert into mygrptable values(1103,'http://www.himolde.no/~molka/sometext.txt');


create index mygrpindex on mygrptable (docs )
  indextype is ctxsys.context
    parameters ('DATASTORE mygrpurl');
    
    
    
select  id,docs,score(1) from mygrptable where contains (docs,'Clouds',1)>0;