|
|
|
Re: Data from Oracle to SQL Server [message #70244 is a reply to message #69452] |
Fri, 10 May 2002 10:47 |
Nanakos Chrysostomos
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
suppose you want to create a comma-delimited file for the
following table:
Table BATTER:
name varchar2(30),
hr varchar2(3),
rbi varchar2(3),
batting_avg varchar2(5)
To make the file, write the following script:
-----------------------------------------------------------
set pagesize 0
set pause off
set header off
spool ASCII_FILE
select name||','||hr||','||rbi||','||batting_avg
from BATTER;
spool off
------------------------------------------------------------
Note that the commas will serve as the delimiters, and can be
easily changed to whatever you need. Also, Oracle adds ".lst" to the name
of the spool file unless you specify another extension.
Good luck!
|
|
|