Unique Filename in SQLPlus Spool

Hey Everybody, here I am again.

I was wondering if it is possible to make a unique filename in a spool command I have made some listings with variables in them with SQLPlus.

spool namelist

select name, adres
from person
where name like upper('&NAME%');

When I start this script the output is send to the file 'namelist'. When I start the script again the file 'namelist' will be deleted and exchanged by a new list. Can I make a unique name 'namelist' by putting a timestamp behind it or another way. Now I have to make a list leave SQLPlus move the file to another name start SQLPlus again and start the script again. Is there another sollution within SQLPlus??????

I am waiting for your sollutions.
Thanks

Jeroen Received on Thu Nov 18 1993 - 16:00:13 CET