I need to run multiple queries in a oracle database and to spool then in a same CSV file with multiple tabs. Could you please help me in achieving it.
Asked
Active
Viewed 685 times
0
-
Does this help? https://stackoverflow.com/questions/643137/how-do-i-spool-to-a-csv-formatted-file-using-sqlplus – Abra Jun 10 '21 at 09:46
-
Does "CSV file with multiple tabs" really mean an Excel file with multiple sheets? – Alex Poole Jun 10 '21 at 10:22
-
Yes Alex, the requirement is to have multiple sheets in an excel file. By spooling them with SQLPLUS connection. – John Smith Jun 10 '21 at 11:14
-
@Abra - No that is about generating only one set of SQL result into a CSV file. I have requirement to run , Multiple SQLs by establishing SQLPLUS connection and spool all reports in a single CSV file – John Smith Jun 10 '21 at 11:16
-
Note : There are possibilities , that few tabs can exceed more than 1 million sometimes – John Smith Jun 10 '21 at 11:17
-
Does this help? https://stackoverflow.com/questions/29615196/is-csv-with-multi-tabs-sheet-possible/29616152 – Abra Jun 10 '21 at 11:19
-
@Abra no it was with some other details. – John Smith Jun 10 '21 at 15:56