camn we use 2 instances of set linesize [message #318205] |
Tue, 06 May 2008 02:02  |
melvinRav
Messages: 43 Registered: April 2008 Location: India
|
Member |
|
|
hello ppl
I have the following script , that generates a csv file
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 135
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
spool c:\test.csv
SELECT 'Date'||','||'Distributer Code'||','||'Customer Code'||','||'Product Code'||','||'Sales Units'
from dual
union all
select
set linesize 90 ----can i put the set set line size here
/
spool off
The problem i am facing is that when i open the csv in notepad there is a blank line between the headings ,
this because the size of the heading followed by the data , is of less size ,
can i reduce the linesize in the script , just after
"SELECT 'Date'||','||'Distributer Code'||','||'Customer Code'||','||'Product Code'||','||'Sales Units'
from dual"
but when i tried it its of no avail
can anybosy please help out
|
|
|
|
|
|