Home » Server Options » Text & interMedia » contains query
contains query [message #287331] Tue, 11 December 2007 23:49 Go to previous message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Hii,

I want to get such objects from the data dictionary user_objects such that object_name contain the word 'API'.I used to write the query such that -->

SELECT T.OBJECT_NAME FROM USER_OBJECTS T WHERE CONTAINS(T.OBJECT_NAME,'API')>0;

But it raised error massage --> ORA-00904: "CONTAINS": invalid identifier

Please give the solution and tell me how to used contains in select query.
 
Read Message
Read Message
Previous Topic: Html sectioning and CONTAINS query
Next Topic: Problem with filtering binary documents (.doc, .pdf, etc...)
Goto Forum:
  


Current Time: Tue Apr 23 15:41:19 CDT 2024