Bulk copy

[amits]

Hi ,
Is there any utility in oracle so that i can directly take the dump of a table in a xls or in a word file ,similiar to some BCP command in sybase.
Thanks

[SANJAY_G]

Hi there,

I usually do like this..

1. Set LINESIZE to a value that will accomodate one row in a line.
2. Set PAGESIZE to 0
3. Set colsep ','
4. Spool the file as .CSV you can open this file directly in Excel.

HOPE THIS HELPS.

Sanjay

[amits]

Thanks Sanjay,
I have done the similiar thing ,but i want to know whether there is any command ,that can directly dump the table into some file,i mean except select * from tab name.

[anandharaj]

Hi,
As for as I know there is no direct command available
to convert the table to xl file without using select * command.
It is better to go thro Mr.SANJAY_G's steps.

and also i am not sure, you can check TOAD or PLSQL DEVELOPER Utilities.