OraFAQ Forum: Text & interMedia » Intermedia text Wildcard (%

Home » Server Options » Text & interMedia » Intermedia text Wildcard (%_)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Intermedia text Wildcard (%_) [message #366395]

Thu, 04 November 1999 16:25

Ravi
Messages: 251
Registered: June 1998

Senior Member

Has anyone tried wildcard character in context query using contains eg
table resume
resume_id number(10)
content clob
select resume_id from resume where contains(content,'ja%',1)> 0;
Context index is created on content column the database is 8.1.5 If i execute this query no rows are returned

Report message to a moderator

Re: Intermedia text Wildcard (%_) [message #366397 is a reply to message #366395]

Tue, 09 November 1999 18:38

Ray Fitzgerald
Messages: 1
Registered: November 1999

Junior Member

Check ctx_user_index_errors view for any errors encountered
during indexing. The owner of the table must
grant READ on the directory to user ctxsys. This is probably the problem.

Report message to a moderator

Re: Intermedia text Wildcard (%_) [message #366398 is a reply to message #366395]

Wed, 10 November 1999 02:04

Sunil
Messages: 132
Registered: September 1999

Senior Member

I have been successful with older ConText. I know there was a parameter which tells ConText if wild-cards are allowed or not. I think it's part of Lexer.
Aye me back if you can't find it.
Sunil

Report message to a moderator

Previous Topic:	ConText Cartridge Installation / Unix
Next Topic:	Natural Language Queries?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 16:33:50 CST 2025