XQuery negate regex

Oct 7 '15 Comments: 6 Answers: 2

3

Im searching for a way to negate a regular expression in xquery Using Oracle with the XMLQuery function.

Ill give an example first:

XMLQuery(
    'for $number in ("2a2", "32", "1234", "12", "32a3", "")
    where ora:matches($number,"^[0-9]{4}$")

    return xs:integer($number)'
    passing xml RETURNING CONTENT
    )

this works perfect except one thing. I want…

Open Full Question