Re: Spool Command

"Robert J. McCallister" <rmccalli_at_iag.net> wrote:

>Is their a way to concatenate the sysdate with a file name using the
>spool command?
 

>What I am hoping to do have is something like:
 

> filename.081696
 

>Thanks for any assistance.

Something like this should work :

column a1 new_value dato;
select sysdate a1 from dual;
spool fil_&dato
select username from sys.dba_users;
spool off;

--
Arne Nervik, DBA
Telenor Media AS, Norway
Email : arne.nervik_at_oslo.media.telenor.no