Convert the entire table data as csv format and insert it in another table's single column.

Hi Team,

Let's assume the employees table receives new records every hour. When loading these new records into the table, it is truncated, and the new records are loaded. Due to this process, we need to store the entire old table data by converting it to CSV format and inserting that data into another table.

Note:

The CSV table contains 24 rows for every day. Each row contains loaded time and csv data in a single column.

Could you please provide any approach?

Thanks in Advance..!