Using SQL/XML functions XMLExists and XMLCast

This article reveals how you might use SQL/XML functions in your SQL statements accessing XML data, thus taking advantage of both SQL and XML in a single query. In particular, the article focuses on the XMLExists function that is used to evaluate the XQuery expression passed in, checking whether it returns anything. Also, it covers the XMLCast function that casts its first argument to its second argument of a scalar SQL datatype, such as VARCHAR2, NUMBER, DATE etc.

Read this article...

comments powered by Disqus