Hello please help me sql statement

A field contain some long sentence

Eg:- " dengue fever causes lever malfunction eadache and vomiting" like this


i have searching string "yellow fever vomiting "

if any word in the searching string match with the long sentence i have to calculate the percentage.

Eg:- i have two words(fever,vomiting) matching with the string, i have to find the percentage of the that perticular matching string.

result should be in the percentage...


please help me..

S.D.Narasimha

9886619980
narasimha.kumar@arisglobal.co.in






Select Matching_Relevence(Oracle_Text_field, parameter_text_field) from xtable

Example Oracle_Text_Field = "dengue fever causes lever malfunction
headache and vomiting"
parameter_text_field = "Yellow dengue fever"