Export some SQL queries in one Excel file

lemalhu

Hi,

i'm using SQL Developer 4.2.0.

I have 5 queries and want them to be on 5 different sheets but in one Excel file.

At the moment i use this but there is another problem, i get one csv sheet but there is just one columns with all of my results.

Is there any possibility to solve one of those problems? i have READERS_ONLY function so i cant export the whole thing.

Thank you for your help

thatJeffSmith-Oracle

if you save your queries as views, yes

https://www.thatjeffsmith.com/archive/2018/01/exporting-multiple-tables-to-a-single-excel-file-using-sql-developers-cart…