Re: Help on SQL*Plus Command

Hey Chinunta,

     Alter your line just a little bit by adding quotes:

DEFINE FILE_NAME = "C:\TEMP\BT&W_DATE_BEG" Jay!!!

Chiunta Chen wrote:

> Here is what I tried to accomplish
>
> ACCEPT W_DATE_BEG PROMPT "Enter Period Start Date (mmddyyyy): ";
> ACCEPT W_DATE_END PROMPT "Enter Period End Date (mmddyyyy): ";
>
> I want to generate a spool file with names like BTyymmdd in c:\temp.
> I was stumped at
>
> DEFINE FILE_NAME = C:\TEMP\BT .........
> SPOOL &FILE_NAME
>
> Is my goal possible?
>
> Please also send a copy of your response to my e-mail. I appreciate your
> help.
Received on Tue Sep 07 1999 - 17:09:08 CDT