Re: newbie: simple sql query to create .csv file for excel import

Use this script via SQL*PLUS, it give you .csv file, I use it everyday.

Dong Tang

set feedback off
set term off
set flush off
set linesize 400
set numwidth 20
set pagesize 0
set colsep ','
ttitle off
btitle off
set echo off
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi'; set heading on
spool d:\temp\dump.csv;
select * from your_table
spool off;
exit

Volker Peter wrote in message <37B28B65.71034440_at_step.de>...
>Hello you all out there,
>
>i'm new with Oracle SQL programming and i have a simple SQL Question:
>
>I must run a select statement on my Adress-Table and write down this
>data to a .csv file for importing this into winword or excel for working
>with that data.
>I read some documentation about Oracle Export but this seems to me that
>this won't work as i expected it to work. If you have any comments or
>ideas regarding this problem, please let me know - also if there is a
>internet website or a usergroup website where some example coding is
>shown to me so that i can learn from that sql code.
>
>If you have any ideas please let me know.
>
>Thank you !
>
>Volker
>
Received on Thu Aug 12 1999 - 15:48:36 CDT