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