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

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 -->


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

Please give the solution and tell me how to used contains in select query.
Re: contains query [message #287341 is a reply to message #287331] Wed, 12 December 2007 00:40 Go to previous message
Barbara Boehmer
Messages: 8609
Registered: November 2002
Location: California, USA
Senior Member

In order to use the contains operator, you must have created a context index on the table that you are querying. However, such an index cannot be created on a view and you should avoid creating such things on data dictionary views such as user_objects. This is not an appropriate use for contains. You should just use LIKE.
Previous Topic: Html sectioning and CONTAINS query
Next Topic: Problem with filtering binary documents (.doc, .pdf, etc...)
Goto Forum:

Current Time: Sat Oct 22 22:40:30 CDT 2016

Total time taken to generate the page: 0.08894 seconds