My problem is that i have a table with 500000 rows and want to export all records into excel. The excel file must be divided into two excel files each with 250000 rows for example . Is there a way of achieving this automatically via Toad analysts or toad data point ? If so, how?
the steps of automation process
exporting SQL query to excel file
system counts rows if more than 250000 split the excel file into file with 250000 rows at most and create another excel file to put the rest of rows and so on
the system attach each excel file in mail message and send it to recipients