4

Export SQL Results To Excel Using SQLPLUS

Here is quick tip on how to easily export SQL results into an excel file.

Step 1: Login into database using SQL PLUS

Step 2: Set markup using below command

SET MARKUP HTML ON

Step 3: Spool the output to a file.

SPOOL C:\TEMP\MYOUTPUT.XLS

Step 4: Run your SQL Query

SQL QUERY

image

Step 5: Set the Spool Off.

image

Step 6: Open the output XLS file to view the output.

Prashant
 

Click Here to Leave a Comment Below 4 comments