Re: Save only table values to a flat file without select statement

On 7 Jan 2004 08:25:39 -0800, watuni2000_at_yahoo.co.nz (Tyler Smith Watu) wrote:

>Is it possible to write the contents of a table to a flat file
>without a select statement included?
>

Yes

>i.e if the table is blank the flat file is blank and if the table
>contains 1 record the flat file contains only the one record too ?

Sure

Just save the select to a file, and include a spool command prior to the select
Then run the file by using @<file>
Of course this is documented

--
Sybrand Bakker, Senior Oracle DBA