Resolution:
Description:
===========
Creating database queries using Oracle data types in backingstore.

Environment:
===========
TIBCO BusinessEvents 3.x/4.x
All Operating Systems

Resolution:
========
Table and column names are included in double quotes (“) and they are case sensitive in the SQL statement.

There are some special settings required for nested tables (e.g. concept references), but the syntax is straightforward Oracle. For datetime types use t.ENTITY."myDatetimeProperty"."tm" because this is a structured type.


select t."ENTITY"."xYzconceptproperty",t."ENTITY"."conceptproperty" from d_concepttable t where t.ENTITY."aBc"='anyvalue'

-- based on the BackingStore example (FraudDetection)
select t.ENTITY."EXTID$",t.ENTITY."Debits"
from d_account t
where t.ENTITY."AvgMonthlyBalance"='10000';