Forum Stats

  • 3,838,621 Users
  • 2,262,385 Discussions
  • 7,900,708 Comments

Discussions

Export some SQL ORACLE queries in one Excel file

lemalhu
lemalhu Member Posts: 14
edited May 20, 2020 10:21AM in SQL & PL/SQL

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.

pastedImage_0.png

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

Tagged:

Answers

  • Tubby
    Tubby Member Posts: 6,987 Bronze Crown
    edited May 20, 2020 10:21AM
    lemalhu wrote: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. 
    pastedImage_0.png

    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

    Please try the appropriate forum.

    Cheers,