My Oracle Support Banner

OBIEE 11g|12c: Why Does a Physical SQL Query Have Escape Sequences In It? (Doc ID 2230862.1)

Last updated on MARCH 31, 2017

Applies to:

Business Intelligence Reporting and Publishing - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Goal

When sending a query to a database through ODBC the physical SQL looks like this in the log:

select distinct T38."<column>" as c1,
  T38."<column>" as c2,
  {fn concat({fn concat(T38."<column>", '-')}, T38."<column>")} as c3
from "<database>"."<table>" T38

Is this expected?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.