467,114 Members | 1,266 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,114 developers. It's quick & easy.

problem with Spool ..

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
  • viewed: 1903
Share:
1 Reply
debasisdas
Expert 4TB
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.

Similar topics

1 post views Thread by Mario Horvat | last post: by
1 post views Thread by david_0 | last post: by
reply views Thread by prithvis.mohanty@gmail.com | last post: by
reply views Thread by prithvis.mohanty@gmail.com | last post: by
reply views Thread by Michele | last post: by
reply views Thread by Robert | last post: by
1 post views Thread by orajit | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.