problem with Spool ..

akaley

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..

Nov 30 '07 #1

debasisdas

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

Nov 30 '07 #2