Oracle Text for partial string search
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.