Concatenating different data with the same ID

I am required to write a SQL query to migrate the data into an Excel file, I’m able to transfer data from other tables using ORA_EXCEL but I am unable to do the same for this particular part as it requires me to add them into this format. So I planned to create a new table and call it from that new table. I’m currently using Oracle 10g. Below shows an example of the table that I have

Right now I’m trying create a table with the concatenated data based on the similar BOOK_ID and sort the Information in the BOOK_DESCRIPTION by Date.

Please help!!! and Thank you in advance.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.