Jump to content

Can't understand this query result. Need help


geroid

Recommended Posts

Hi

I have a table called docs with 2 columns 'id' and 'text' and have inserted the following information

INSERT INTO docs VALUES (1, ‘Oracle stuff’); 
INSERT INTO docs VALUES (2, ‘more Oracle stuff’);
INSERT INTO docs VALUES (3, ‘SQL Server stuff’);
COMMIT;

 

I then run the following query as part of a college lab. I can't understand the output or what this query is asking. Can you help? The query is:

 

SELECT SCORE(1) FROM docs WHERE CONTAINS (text, ‘Oracle’, 1) > 0; 

 

The output is:

SCORE(1)
-----------
          4
          4

 

I don't understand what the two 4s refer to.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.