SQL & PL/SQL

Hello There,

I would like to know how can I merge rows based on common column values. Below are the details:

(A): Sample Query

SELECT 1925696 Trx_ID, 101 Line_Number, 'LINE' Trx_Type, NULL Line_Ref, 10  Amount, NULL Tax_Rate FROM dual UNION ALL

SELECT 1925696 Trx_ID, 102 Line_Number, 'LINE' Trx_Type, NULL Line_Ref, 20  Amount, NULL Tax_Rate FROM dual UNION ALL

SELECT 1925696 Trx_ID, 103 Line_Number, 'LINE' Trx_Type, NULL Line_Ref, 30  Amount, NULL Tax_Rate FROM dual UNION ALL

SELECT 1925696 Trx_ID, 104 Line_Number, 'TAX'  Trx_Type, 101     Line_Ref, 1.9 Amount, 19      Tax_Rate FROM dual UNION ALL

SELECT 1925696 Trx_ID, 105 Line_Number, 'TAX'  Trx_Type, 102     Line_Ref, 1    Amount, 5        Tax_Rate FROM dual UNION ALL

SELECT 1925696 Trx_ID, 106 Line_Number, 'TAX'  Trx_Type, 103     Line_Ref, 3    Amount, 10      Tax_Rate FROM dual

(B): Output from above sample query:

Common Column Values:

1. Column TRX_ID is the same for all rows

2. Column LINE_NUMBER  whose TRX_TYPE's (LINE)      =   LINE_REF  whose TRX_TYPE's (TAX)

(C): Expected Output:

Could you please advice on the SQL query?

Thank you and look forward to hearing from you.

Regards,

Don