Re: Copy data out from table...?

you can create a sql script like thie following:

spool filespec
select column1||'any_delimeter'||columns2||'any_delimeter'|| etc from table_name
where....
spool off

this will write the contents of the table to a file specified by the filespec.

was this what you needed?
(I know nothing of Sybase =p)

Sayoni wrote:

> hi guys,
> i would like to know the Oracle equivalent of Sybase's bcp out. Basically
> all I would like to do is be able to copy data out from a table and specify
> the column and row delimiters.
> any help much appreciated. am new to oracle.
> sayoni
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 05 2000 - 21:22:02 CST