Solved spooling in to excel

December 15, 2014 at 19:40:16
Specs: Windows 7
why when i run the following (in ORACLE):
Set echo off;
Set define Off;
Set feedback Off;
Set serveroutput On;
SET PAGESIZE 0
SET LINESIZE 1000
spool C:\testfile.xls
SELECT name||','||address||','||state FROM TEST;
Spool Off;
Set define On;
Set feedback On;

instead of the data in written to the testfile.xls i get the actual SELECT statement


See More: spooling in to excel

Report •

#1
December 16, 2014 at 11:27:14
✔ Best Answer
One of the Oracle system variables you are SETting is probably causing your issue. Check out this link:

http://www.dba-oracle.com/t_create_...

message edited by nails


Report •
Related Solutions


Ask Question