Re: SQL*PLUS Variable assignment

From: Janusz Wojdyla <jwojdyla_at_dns.kisr.edu.kw>
Date: 1995/09/10
Message-ID: <1995Sep10.015617.4287_at_bbs.sd68.nanaimo.bc.ca>#1/1


In article <42kang$12l_at_news.ios.com>, snowden_at_haven.ios.com (Roger Snowden) says:
>
>Is it even possible to dynamically assign variables in sql*plus? We have
>a developer that wants to create a spool file name dynamically,
>constructed from SYSDATE, like: 0905something.rpt.
>
>Is this doable?
>
>TIA
>
>Roger

Try to use environment variable inside sql command file. I am using for example $HOME to spool results into user's local directory. Janusz


Dr. Janusz Wojdyla       Tel. (965) 48-36-100 ex. 5317; Res. 48-84-086
KISR, Finance Division   Fax  (965) 48-30-432 
P.O. Box 24 885                     48-46-891 
13 109 Safat, KUWAIT     E-mail  jwojdyla_at_safat.kisr.edu.kw
                                 jwojdyla_at_161.252.2.202
-------------------------------------------------------------------------
Received on Sun Sep 10 1995 - 00:00:00 CEST

Original text of this message