Re: SQL*PLUS Variable assignment

snowden_at_haven.ios.com (Roger Snowden) wrote:
>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.
>

Dear Roger,

We're using UNIX, and we're doing exactly that.

In the UNIX script:
  sqlplus _at_name_of_script `date '+%y%m%d'`

In the SQL script:
 SPOOL myfile.&1

Result is a file called myfile.950905

Louise Miller Received on Thu Sep 07 1995 - 00:00:00 CEST