Oracle Text (MOSC)

MOSC Banner

Oracle Text for partial string search

edited Feb 10, 2014 7:40AM in Oracle Text (MOSC) 6 commentsAnswered ✓

Hi,

I'm working on an

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP.

I've a vehicle table and I need to search vehicles per plate_number.

At the moment the where clause is mostly like:

where lower(plate_number) like '%'||lower_parameter||'%'

The parameter entered is most of the time a part of full plate, that's means that if I search for 'AA000' I would like to find also 'AA000BB'

I tried to create an oracle text but it finds just the whole word entered as parameter; the previous example doesn't return any results.

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