My Oracle Support Banner

Can Goldengate Use DECODE Function For SQL (Doc ID 2185613.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

We have several unique function indexes as follows:
* DECODE("Column1",'ACTIVE',"Column2",NULL)
* DECODE("Column3",'CURRENT',TO_CHAR(NVL("Column4",0))||TO_CHAR(NVL("Column5",0)),NULL)
It is unclear how CDR can be configured to address the above unique function indexes.

Cause

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
Symptoms
Cause
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.