Tags » XQuery

How To : using OUTER JOIN with XMLTABLE or XQuery

Here is a short reminder post about how to use or implement outer join in XMLTABLE or XQuery.

The typical scenario for which we would need to outer join is the flattening of a master-detail hierarchical structure with some logical records missing the detail part. 1,770 more words

HowTo

Tip: View document permissions in MarkLogic

MarkLogic is uber secure. So secure it doesn’t let you see role names when viewing document permissions. This tip shows you how to resolve this foible… 264 more words

MarkLogic

XQuery Templates : SOAP UI for generating SOAP Response Templates

SOAP UI can be quite useful while developing OSB project ,in terms of readily generating response templates that can be used for

OSB

XQuery on the road

Introduction

Read this if you are interested in running and developing code in XQuery on offline Android devices.

I like to travel and I like to write a bit of XML based code. 468 more words

How I made Markit CDS play nice with other databases

The problem

Markit CDS is a source for credit default swap data for quoted companies, private companies and governments. Academic researchers with access to a resource like this usually need to cross reference the securities’ fundamentals or financial data. 718 more words

ISIN

Just noticed that since version 9.7 the well-known Saxon XSLT processor actually implements the fn:default-language function, which I invented back in 2015. I feel really excited! :-)

Programming

XQuery 3.0 : We're getting closer...

Stumbled upon this while developing a user-defined operator (for a future work related to JSON) :

SQL> select operator_name, function_name, return_type
  2  from dba_opbindings
  3  where operator_name = 'XQWINDOWSEQUENCE';
 
OPERATOR_NAME       FUNCTION_NAME                         RETURN_TYPE
------------------- ------------------------------------- ------------------
XQWINDOWSEQUENCE    "SYS"."XQWINDOWSEQUENCEFROMXMLTYPE"   XMLSEQUENCETYPE 
… 163 more words
XQuery