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.