0

I need to save results of multiple queries into a single excel sheet. Is there any way to do this in Oracle SQL Developer?

Improve this question
1
  • spool the output of all queries from the same SQL worksheet. into a csv file Commented Feb 14, 2018 at 15:56

1 Answer 1

Reset to default
3

No.

Query results exports for XLSX go to a single file.

So you could copy and paste the results over, which is admittedly, not ideal. And you could try what others have suggested, spooling the data as CSV to a file, and let Excel figure it out later.

Here's one way to do it, but will require CREATE VIEW privs for your Oracle user:

Create the queries as VIEWs, and then export the views to a single Excel file. Each view will go to a separate workbook.

I talk about that here.

Open your cart, drag in the views, set your options, and export to single excel file.

enter image description here

enter image description here

If it were me, I'd create an Oracle Application Express app, and keep the data out of Excel, period.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Hi Jeff, hope you dont mind If I have a related question:) I read one of your articles describing how to export the tables with BLOB columns from a table and we are exporting them as sqlldr files from SQL dev. That seems to be the only viable option for us(in one particular module) now which is conveniently portable for continuous deployments. Are there any other options in SQL dev which is convenient to export BLOB ?. If the answer is detailed, I will ask it as a separate question. Appreciate your time!
that's the best way to get BLOBs out...unless you want to talk about Data Pump

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.