Re: sqlplus ... spooling to a file

On Tue, 2 Sep 2003 12:40:56 +0200, "Jon" <aaa_at_bbb.ccc> wrote:

>Hi, when spooling to a file a select command, I am trying to change change
>the name of the file so, is it posible to use a bind variable (with the
>actual date) to store the name of the file that I want to spool to?
>
>Thanks
>

a define will do

column date new_value _datum
set termout off
select to_char(sysdate,'dd-mm-yyyy') date from dual;
set termout on

spool your_file_&_datum..lis

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 02 2003 - 13:50:01 CEST