Home » Server Options » Text & interMedia » How to use Oracle text (split from hijacked topic "Find Words in a String")
How to use Oracle text (split from hijacked topic "Find Words in a String") [message #618466] Sat, 12 July 2014 02:30 Go to previous message
sss111ind
Messages: 613
Registered: April 2012
Location: India
Senior Member


 select *  from emp
    where contains(ename,'MILLER')>0 and rownum < 10;
    
ORA-00904: "CONTAINS": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:
Error at Line: 2 Column: 11



How to user Oracle text.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Oracle Text index catsearch order by close match
Next Topic: Is there a way to customize the BASE_LETTER conversions that oracle text does
Goto Forum:
  


Current Time: Sun Apr 05 06:09:49 CDT 2020