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