Re: new to oracle...HELP!

Hi,
 your best bet is to use sqlplus,
 write a sql query that spits out the format you want,  and spool the result to a file.

 example:

SQL> spool /tmp/my_file

SQL> select col1||';'||col2 ... from mytab;

.....

SQL> spool off

depending on what you want, you might need to play with 'set linesize', 'set heading', 'set arraysize', 'set pagesize' etc.

HTH Karsten

In article <84uhbs$4qf$1_at_nnrp1.deja.com>,   sayoni_at_my-deja.com wrote:
> hi gurus,
> coming from a sybase background i am at a loss trying to figure out a
> way to export data to a file. I was wondering if there is any way to
> provide a column and a row delimiter when exporting the data out from
a
> table into the file. any help much appreciated.
> tia.
> sayoni
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 05 2000 - 07:49:00 CST