"M. Gedecke" <spam_at_gedecke.de> wrote in message
news:am4ntc$k3s$1_at_redenix.uni-muenster.de...
> i want to create an empty file which has the name of the content of a
> variable and an ending. i thought of something like that:
>
> variable a number
> a:=select count(*) from user_verwaltung where sicherungs_art=1 and
> geloescht_am is null;
> spool 'variable a'.sve';
> spool off
>
> could someone please help me with the syntax of the commands? the name of
> the file should be something like: 23.sve
SQL> define a=23
SQL> spool &a..sve
SQL> select sysdate from dual;
SYSDATE
16-SEP-02
SQL> spool off
SQL>
note the 2 dots to (in this case) prevent the default extension of lst being
added to the file.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Mon Sep 16 2002 - 10:41:46 CDT
