I checked it.
The problem is that he has chr(10) (newline) in his data so the output is
truncated.
Using select replace(field,chr(10),'') instead of select field make the
problem go away.
BTW - I also tested doing the replace on numeric fields and it comes out ok.
No need to check if the field
Thanx Guys.
I used a combination of repalce/translate to remove the unwanted
characters.it worked out.
thanx everybody.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: oraora oraora
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
oraora oraora wrote:
Guys,
i want to export table data into a CSV file.
i am using the script below to do the same.
--
set wrap off
set linesize 2000
set feedback off
set pagesize 0
set verify off
set termout off
syntax similar to this.
-Original Message-
From: oraora oraora [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 23, 2002 11:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Migrate table data to CSV file - Urgent help !!!
Guys,
i want to export table data into a CSV file
Guys,
i want to export table data into a CSV file.
i am using the script below to do the same.
--
set wrap off
set linesize 2000
set feedback off
set pagesize 0
set verify off
set termout off
spool ytmpy.sql
prompt prompt