Oracle Text (MOSC)

MOSC Banner

oracle text search contains

edited Mar 16, 2017 6:11AM in Oracle Text (MOSC) 5 commentsAnswered ✓

Hi helpers,

i have a table with part numbers and part descriptions.

The partno. looks like KD-005657

When i want to search for this i use

select * from parts where contains(partno,'KD-')>0

But there is no result.

Only using contains(partno,'KD%') creates a result.

I tried these also: KD\-, KD& found in documentation to text query.

How could i find results when seraching all partno with KD- ?

Thanks for you response.

Frank

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