Re: please someone help me with sql

On Mon, 16 Sep 2002 15:53:42 +0200, "M. Gedecke" <spam_at_gedecke.de> wrote:

>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
>

column zahl new_value fil
select count(*) zahl
from benutzer_verwaltung
where sicherungs_art = 1

   and geloescht_am is null
spool &fil..sve
spool off

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Sep 16 2002 - 12:08:23 CDT