Oracle Text (MOSC)

MOSC Banner

Contains

edited Jun 28, 2018 7:21AM in Oracle Text (MOSC) 4 commentsAnswered

Hi,

i need more information about use of contains clause in Oracle text.

If i try to select all spa companies in a table i write these select:

select score(1), des from p06_enti_est_pres

where contains(des, '(s.p.a.)', 1) >0

order by score (1) desc;

but as i not attended i found this string "A.P.S.P. Fondazione San Nicolo'" and i don't fount string contanis spa without dot.

If i search string with no dot i don't found string with dot.

Anyone can describe me how contains work?

Thank you,

Mariano

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center