Re: SQL*PLUS and placing sysdate in spool filename

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 27 Jan 1999 20:03:35 GMT
Message-ID: <36af70a9.109250874@inet16.us.oracle.com>

On 27 Jan 1999 19:36:56 GMT, "Pat Gorden-Ozgul" <gorden_at_xs.bis.bnl.gov> wrote:

>We run spool files in batch mode and would like to place the actual date in
>the stored spool filename itself for auditing purposes.
>

Add this as the first lines of the batch

set heading off
select 'Starting process '||to_char(sysdate,'DD-MON-YYYY HH24:mi:ss') from dual; set heading on

>If you know how, pls email me: gorden_at_bnl.gov. Thx.

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jan 27 1999 - 14:03:35 CST