Description of listagg

LISTAGG( [ ALL | DISTINCT ] measure_expr [, ' delimiter ' ] [ listagg_overflow_clause ] )

  [ WITHIN GROUP ( order_by_clause )  ]

  [ OVER ( [ query_partition_clause ] ) ]