In one of my earlier posts, I had showed some examples of using the CASE and EVAL column conversion functions available in GoldenGate.
Let us today take a look at two other functions STRCAT and STREXT.
STRCAT basically enables us to concatenate two strings or two character columns.
The STREXT function on the other hand is used to extract a portion of a string.
For example in our source database we have a table MYPHONE with the following structure:
SQL> desc myphone
Name Null? Type
—————————————– ——– —————————-
AREA_CODE
Continue reading Using the GoldgenGate column conversion functions – STRCAT and STREXT


Popular Posts