Thursday 4 June 2015

Script For Row Level Record TO Column Level Display

Actual Record :  

    1,  Arun,
    2, Mano
    3, Devaraj

Query For Chaging the Record Into Columsn level:

select
  LISTAGG( DEFAULT_DIST_CCID,',' )  WITHIN GROUP (ORDER BY Invoice_id)
from
  Ap_invoice_Lines_All@Apps_Prod Where Invoice_id=18000

Script Output:

Arun,Mano,Devaraj

No comments:

Post a Comment