Wednesday, March 24, 2021

OIC - Use of Translate function

Requirements: To remove the aposthrope (') from a string.

Format:

translate($variable_name,"'",'')

We can also replace one special char to another one using translate function.

No comments:

Post a Comment

Featured Post

OIC Blog: Creating Unique Account IDs Using XPath | Use of distinct-values()

Introduction In Oracle Integration Cloud (OIC), sometimes the source contains multiple Impacted Account IDs, and the same Account ID may app...