Re: SQL*Plus SPOOL Problem

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