全文検索条件式の指定例を次に示します。なお,例では表「reports」のSGMLTEXT型の列「doc」を検索対象としています。また,「概要」および「目的」は,最上位構造「文章」の下位構造です。
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章[概要{"COMPUTER"}]' ) IS TRUE
SELECT title FROM reports
WHERE contains(doc, '文章[概要{SYNONYM(USR01, "COMPUTER")}]' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章[概要{SYNONYM(USR01, "COMPUTER")
AND "NETWORK"}]' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章[概要{SYNONYM(USR01,
"COMPUTER") AND SYNONYM(USR01,
"NETWORK")}]' ) IS TRUE
SELECT title FROM reports
WHERE contains(doc, '文章[概要{PROXIMITY(SYNONYM
(USR01, "COMPUTER"),<=10, CHARACTERS,
ANY_ORDER,SYNONYM(USR01,
"NETWORK"))}]' ) IS TRUE
SELECT title, author FROM reports
WHERE contains(doc, '文章[概要{PROXIMITY(SYNONYM
(USR01, "COMPUTER"),<= 20, CHARACTERS,
ANY_ORDER, SYNONYM( POLITICS,
"NETWORK"))}]' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章[目的{"COMPUTER"}] AND文章[概要
{"NETWORK"}]' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章{"NETWORK"}' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章[*[コラム{"COMPUTER"}]]' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '?[?[コラム{"COMPUTER"}]]' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章[コラム=2{"COMPUTER"}]') IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(doc, '文章{SOUNDEX_EXP("COMPUTER","AE") AND
SOUNDEX_EXP("NETWORK","AE")}' ) IS TRUE