Re: SQL*Plus SPOOL Problem
Date: Wed, 14 Oct 1998 12:07:04 +0200
Message-ID: <701t60$r21$2_at_news1.skynet.be>
Hi,
where running Unix it is possible to spool to file referenced by an
environment variable :
e.g. :
myfile=/tmp/myfile.`date +%x`
sqlplus usr/pw
spool $myfile
etc....
This trick will probably work also under NT, or other operating systems. good luck
Thierry Poels
DBA & Unix System Manager for VTB-VAB
HTTP://www.vab.be
Vakalis wrote in message <362463B5.186FAB9_at_sni.gr>...
>I want to spool the results of a select statement daily to a file with
>the extension of the current date.
>Using a SQL*Plus variable where previously I assigned the current
>sysdate, how I can pass it to the SPOOL command? Whatever i tried, it
>has failed, getting a message saying that it is impossible to create the
>file.
>Is there anyone that can help me?
>
>Thanks in advance
>Lefteris
>
Received on Wed Oct 14 1998 - 12:07:04 CEST