| How to extract datas from table to csv [message #76152] |
Wed, 08 December 2004 21:39  |
Selva
Messages: 15
Registered: June 2001
|
Junior Member |
|
|
have a doubt while spool the records from a table to csv i had a problem,
actually my requirement is when we use the colsep it places the each data to each cell of the excel,but in some cases in table one column values are inserted as
for example column address has the value
address1,address2....etc in this case the column delimited values will be placed in the next cells,ie means one column has placed in multiple cells,
so the issue is.. in that case how to place each column value in each cell..?
please find the following i used
SET ECHO OFF VERIFY OFF PAGESIZE 0 TERMOUT OFF TRIMSPOOL OFF LINESIZE 6000 COLSEP ','
SPOOL /appl/noa/abinitio/sample.csv
select ,,,,,,,,,,,,,,,,,,,query
SPOOL OFF
SET TERMOUT ON
can u please send me a reply as soon as possible...?
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
