Re: spool command in sql plus
From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Wed, 30 Jun 2010 18:39:08 +0200
Message-ID: <i0frvd$cph$00$1_at_news.t-online.com>
Hi Chris,
Date: Wed, 30 Jun 2010 18:39:08 +0200
Message-ID: <i0frvd$cph$00$1_at_news.t-online.com>
Hi Chris,
try something like this
def spoolfile
col currentsysdate NEW_VALUE spool_file_timestamp
select '<your_spoolfile_prefix>' || to_char(sysdate, 'yyyy_dd_mm_hh24miss' ) currentsysdate
from dual;
def spoolfile
hth
Kay
Received on Wed Jun 30 2010 - 11:39:08 CDT