SQL & PL/SQL

Hi All,

I want to concatenate all the columns expect Customer_Key. While doing this Listagg Function will accept only 4000. So please help me to close this issue.

Oracle Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Table_Name:

Customer_Data

Sample Data:

CUSTOMER_KEY     ADDRESS_LINE1    ADDRESS_LINE2      ADDRESS_LINE3     ADDRESS_LINE4     ADDRESS_LINE5    POSTAL_CODE   COUNTRY_CODE    PHONE_NUMBER

      101                       ABCDHBJ                HNKJVNKJDV         HFKJDVHDSKJ                HVHK                 JGSBCHJS                         546                  NN                          6376676

      102                      CJNJKN                  GASJ                          HKJSD                         FYTFYTFG             GFVGV                             436                  RS                          5575676

      103                      NJKNJ                    JNKJN                         JNKJNKJ                    BJBJ                                                                 78                  UU                              8979796

      101                       JKDK                     JNVDJFNV                       FV                            FVF                                                               567                NA                                86876

      105                       GJHGJH                   BHJB                        FTYFTF                     VJHBJH                         VBJBJH                       3543               SS                                876876

      101                      RAHHJ                      JNBKJNJ                      BKBN                      GVHV                          HBJHBJH                       76                NN                                76567               

      101                      GFHJH                   HBJHBHJ                           BJBJ                      BJBJH                          HBJH                            5465          NA                                 657

Required output:

CUSTOMER_KEY        ADDRESS

    101                              ABCDHBJ HNKJVNKJDV FKJDVHDSKJ HVHK JGSBCHJS 546 NN 6376676   \n JKDK JNVDJFNV FV FVF 567 NA 86876 \n RAHHJ JNBKJNJ BKBN GVHV HBJHBJH 76                                             NN 76567 \n GFHJH HBJHBHJ BJBJ BJBJH HBJH 5465 NA 657                  

    102                              CJNJKN GASJ HKJSD FYTFYTFG GFVGV 436 RS 5575676

    103                              NJKNJ JNKJN JNKJNKJ BJBJ 78 UU 8979796

    105                              GJHGJH BHJB FTYFTF VJHBJH VBJBJH 3543 SS 876876

Thanks,

Pradeep D.