HiRDB XML拡張機能 HiRDB XML Extension Version 9
全文検索条件式の指定例を次に示します。なお,例では表「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
All Rights Reserved. Copyright (C) 2010, 2015, Hitachi, Ltd.