Finding Text Using Oracle Intermedia

Oracle Intermedia is a server that allows advanced text searches in an Oracle database. If you have an Oracle database, you can search for text in messages and response bodies using the Find window.

Note: To use this functionality, you must configure Oracle Intermedia.

The syntax of the search is similar to the syntax of a search on the Web. Some examples include:

A search for "KANA" finds all messages with the word "KANA" in them.
A search for "KANA and Oracle" finds all messages with both "KANA" and "Oracle" in them. It would not search for the phrase "KANA and Oracle". To have Oracle Intermedia search for "KANA and Oracle" you type "{KANA and Oracle}." Searches such as "KANA or Oracle" or "KANA not Oracle" behave similarly.

Some symbols have a special meaning:

A search for "$decide" finds messages containing words derived from the stem word decide, such as deciding and decision.
A search for "?read" searches for words that are spelled similarly to read, such as real and reed.
A search for "syn(house)" finds messages containing synonyms for house, such as household and home.

If the Oracle Intermedia server does not understand the syntax, KANA Response^TM displays an error message.

Using Escape Characters in a Query Expression

To query on words or symbols that have special meaning to query expressions, such as and & or| accum, execute, you must use escape symbols. Use the symbols in the following table to include escape characters in a query expression:

Escape Symbol	Meaning
{}	Use braces to include a string of characters or symbols in the query. Everything within a set of braces is considered part of the escape sequence.
\	Use the backslash character to include an individual character or symbol in the query. Only the character immediately following the backslash is included in the escape query.

Example:
In the following examples, an escape sequence is necessary because each expression contains an Oracle Intermedia operator or reserved symbol:

'AT\&T'
'{AT&T}'

'high\-voltage'
'{high-voltage}'

Note: If you use escape braces around an individual character within a word, the individual character is used in the escape query. However, the word is broken into three tokens. For example, a query written as high{-}voltage searches for high - voltage, with the space on either side of the hyphen.

Reserved Words

To perform a search using any of the following list of Oracle Intermedia reserved words and characters, use the appropriate escape characters:

Operator	Reserved Word	Reserved Character
And	AND	&
Or	OR	\|
Accumulate	ACCUM	,
Minus	MINUS	-
Not	NOT	~
Near	(none)	;
Stem	(none)	$
Soundex	(none)	!
Fuzzy	(none)	?
Threshold	(none)	>
Weight	(none)	*
First/Next	(none)	#
Max	(none)	:
Wildcard (multiple)	(none)	%
Wildcard (single)	(none)	_
Within	WITHIN	(none)
Grouping (parentheses)	(none)	( )
Grouping (brackets)	(none)	[ ]
Escape (multiple characters)	(none)	{ }
Escape (single character)	(none)	\
Paragraph Searching	PARAGRAPH (used with WITHIN)	(none)
PL/SQL call	EXECUTE EXEC	@ @
Sentence Searching	SENTENCE (used with WITHIN)	(none)
Stored Query Expression	SQE	(none)
Synonym	SYN	(none)
Preferred	PT	(none)
Related	RT	(none)
Top	TT	(none)
Broader	BT	(none)
Narrower	NT	(none)
Broader Generic	BTG	(none)
Narrower Generic	NTG	(none)
Broader Partitive	BTP	(none)
Narrower Partitive	NTP	(none)

How do I read a message?

How do I answer a message?

How do I view customer history?

How do I use message history?

How do I send a message?

How do I review the source of a message?