XQuery - string-join Function


Advertisements

The string-join function is used to concatenate various sequences separated by a given delimiter.

Syntax

string-join($sequence as xs:string*, $delimiter as xs:string) as xs:string

Input Parameters

  • $sequence − sequence of zero or more strings.

  • $delimiter − delimiter to separate the items of above sequence.

Example

XQuery Expression

let $fruits :=
<fruits>
   <fruit>Apple</fruit>
   <fruit>Orange</fruit>
   <fruit>Guava</fruit>
   <fruit>Pinapple</fruit>
</fruits>

return
<results>
   
   <fruits>{
      string-join($fruits/fruit, ',')
   }</fruits>
   
</results>

Output

<results>
   <fruits>Apple,Orange,Guava,Pinapple</fruits>
</results>

Verify the Result

In order to test the above-mentioned functionality, replace the contents of books.xqy (mentioned in Environment Setup chapter) with the above XQuery expression and execute the XQueryTester java program to verify the result.

xquery_string_functions.htm
Advertisements