By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 IT Pros & Developers. It's quick & easy.

problem with Spool ..

P: 17
iam using Spool ..for loading the data into file from select statement..
iam facing some problems...Please give me u r valuable suggestion..

This is the sample code used by me..

set echo off;
set trimspool on;
set verify off;
set feedback off;

set term off;
set colsep ',';

SET linesize 650;
spool D:\HKeeping.csv
select * from emp;
spool out;
spool off;

iam loading the file content sucessfully to the file..But iam faceing problems with headres..Headers are comeing after every 14 th record...
But i want headers(headers means 'empno',empname like this) at starting only..
Nov 30 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,127
You need to set page size also to avoid all that repetation of headers.
Nov 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.