Export results to Excel within script

Question

Is it possible to export the results of a query (a select statement with multiple joins) to an Excel spreadsheet without having to manually export the data, so the script runs the query and also executes the transfer to Excel?

Which RDBMS? Is there any data manipulation involved or is it pure reading? — Gottfried Lesigang
– Gottfried Lesigang, Commented Nov 11, 2015 at 10:04

Jeethu · Accepted Answer · 2015-11-11 10:01:47Z

1

You can use this code in SQL*Plus and Oracle SQL Developer.

Create a .sql file. (Create a text file and change the extension to .sql)

Put the following code in the file:

set heading off
spool excel_1.xls
select 
    first_name||chr(9)||last_name 
from 
    employees;
spool off

Since I have made use of employees table from HR schema, connect hr schema. Execute the script file

@<filename>.sql

you can use any number of columns but each should be separated as shown in above example.

answered Nov 11, 2015 at 10:01

Jeethu

1697 bronze badges

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

1 Comment

Armandt Burger Over a year ago

Thanks, you got me on the right track. i added solution in Question

Collectives™ on Stack Overflow

Export results to Excel within script

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related