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
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