Re: sqlplus: Help with Spooling (path and file questions)

Greg wrote:
> Good morning. I'm new to sqlplus (and Oracle for that matter - but
> loving it!). I'm trying to figure out how to create path and filename
> for the spool command in sqlplus. Here's what I'm trying:
>
> column date_column new_value today
> SELECT 'm:\home\Big Share\Uploads\2006
> Fall\'||to_char(sysdate,'yymmdd')||'.txt' date_column FROM dual;
> spool &today
>
> I'm getting a message that says it is illegal. I've tried
> double-quotes and even no quotes. I'm not sure how to make this work.

It should work. Try not to add any CARRIAGE RETURN after "2006".

>
> One other question, how can you make is so that the .lst is not
> appended to the filename?

You just have to specify another extension.

>I also want to say to a file without an extension.

It's not possible, AFAIK.
"spool dummy." won't do the trick. Received on Mon Oct 09 2006 - 10:05:50 CDT