Connecting Tech Pros Worldwide Forums | Help | Site Map

problem with Spool ..

Newbie
 
Join Date: Nov 2007
Posts: 17
#1: Nov 30 '07
HI..
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..

debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,509
#2: Nov 30 '07

re: problem with Spool ..


You need to set page size also to avoid all that repetation of headers.
Reply