Table contents to flat file

[bang_dba]

hi,

What is the best way to write the Oracle table contents to Flat file ?

Is there any tool provided by oracle for the same

[tabreaz]

There are few ways to accomplish your requirement:

through SQL statment

Select col1 || ',' || col2
from <>

secondly

through PL/SQL procedure using UTL_FILE package

Through PL/SQL u can have better control on formating

[bang_dba]

There are few ways to accomplish your requirement:

through SQL statment

Select col1 || ',' || col2
from <>

secondly

through PL/SQL procedure using UTL_FILE package

Through PL/SQL u can have better control on formating

In first method u specified, does the output need to be spooled ??

[davey23uk]

of course it does

[WilliamR]

Perhaps it is worth mentioning that "spool" is a SQL*Plus command.

[DaPi]

Tom Kyte (of course) has some solutions:
http://asktom.oracle.com/~tkyte/flat/index.html