please someone help me with sql

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

thanx

max Received on Mon Sep 16 2002 - 08:53:42 CDT