Basic XQuery

Basic Hello World

xquery version "3.0" encoding "UTF-8"; let $msg := 'Hello XQuery' return <results timestamp="{current-dateTime()}"> <message>{$msg}</message> </results>
Run Edit

Querying a Document

xquery version "3.0"; doc("/db/apps/demo/data/hamlet.xml")/PLAY/TITLE
Run Edit

Querying a Collection

xquery version "3.0"; collection("/db/apps/demo/data")/PLAY/TITLE
Run Edit

Find all speech elements in Shakespeare with a line containing "hurlyburly"

xquery version "3.0"; collection("/db/apps/demo/data")//SPEECH[contains(LINE, "hurlyburly")]
Run Edit

List all speakers appearing in scene 2 of the first act of Hamlet

xquery version "3.0"; distinct-values(doc("/db/apps/demo/data/hamlet.xml")//ACT[1]/SCENE[2]//SPEAKER)
Run Edit