August 10, 2022;\n\nResolution:\n\nLISTAGG() function is the counterpart of GROUP_CONCAT()\n\nSYNTAX:\n\n\tLISTAGG ([DISTINCT] value_expr [, 'delimiter'])\n\t\t[WITHIN GROUP (order-by-clause)]\n\nSAMPLE:\n\n\tSELECT al_ccode, LISTAGG(concat(al_name, ' (',al_icaocode,')'), ' | ') \n\t\twithin group (order by al_name) AS name\n\n\tFROM airline\n\n\tgroup by al_ccode;\n\n\tcommit; \n\n\tNote: The table used for this example is included in demodb.\n\nActian reference #: 01368379