Handling of CONCAT for Oracle datasources

Solution Verified - Updated -


In Oracle concatenating a zero-length string with another operand always results in the other operand, so null can result only from the concatenation of two null strings, so for example:

CONCAT(null, 'colin')

Would result in 'colin'. To get this behaviour in Teiid you would need to use the CONCAT2 function as CONCAT behaves in the ANSI standard way returning null if either operand is null.


JBoss Enterprise Data Services Platform


Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content