Hi All,
We are in the middle of a migration from 11g to 19c.. And we are seeing different output for LISTAGG function between 11g and 19c..
Anyone noticed this before ? If so, is there a fix ? BTW, DEBTOR_AGENT_INSTRUCTION_REF is a NVARCHAR column
In 11g :
SQL> select LISTAGG (PAI.DEBTOR_AGENT_INSTRUCTION_REF)
2 WITHIN GROUP (ORDER BY PAI.PAYMENT_AGENT_INSTRUCTION_ID) as concat_string from
3 iods.T_PAYMENT_AGENT_INSTRUCTION PAI where
4 etl_source_key='2019|6092|297H0003|1'
5 GROUP BY PAI.ETL_ODS_ACTION_CODE,
6 PAI.ETL_ODS_APPLY_DATE_TIME,
7 PAI.ETL_ODS_BATCH_ID,
8 PAI.ETL_SOURCE_CAPTURE_DATE_TIME,
9 PAI.ETL_SOURCE_KEY,
10 PAI.ETL_SOURCE_SYSTEM_ORIGIN,
11 PAI.ETL_SOURCE_SYSTEM_INSTANCE,
12 PAI.PAYMENT_EXECUTION_ID;
CONCAT_STRING
--------------------------------------------------------------------------------
?u?v???? ?v?}??
In 19c :
SQL> select LISTAGG (PAI.DEBTOR_AGENT_INSTRUCTION_REF)
2 WITHIN GROUP (ORDER BY PAI.PAYMENT_AGENT_INSTRUCTION_ID) as concat_string from
3 iods.T_PAYMENT_AGENT_INSTRUCTION PAI where
4 etl_source_key='2019|6092|297H0003|1'
5 GROUP BY PAI.ETL_ODS_ACTION_CODE,
6 PAI.ETL_ODS_APPLY_DATE_TIME,
7 PAI.ETL_ODS_BATCH_ID,
8 PAI.ETL_SOURCE_CAPTURE_DATE_TIME,
9 PAI.ETL_SOURCE_KEY,
10 PAI.ETL_SOURCE_SYSTEM_ORIGIN,
11 PAI.ETL_SOURCE_SYSTEM_INSTANCE,
12 PAI.PAYMENT_EXECUTION_ID;
CONCAT_STRING
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
???? ????