| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Text, wildcards AND escape characters help
That doesn't work...
SQL> select count(projectid) from project
2 where contains(objectives, '{agent}%', 1) >0;
select count(projectid) from project
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-51030: wildcard query expansion resulted in too many termsReceived on Tue Sep 20 2005 - 12:16:00 CDT
 |
 |