SQL Spool command

[meridian99]

Hi, I have a SQL script that uses the SPOOL command to create a text file & write some records to it. Can I build a filename from variables that use todays date/time as part of the file name? We run oracle v7.3.4

Spool c:\schedule\mydata.dat

I'd like to have the filename as

c:\schedule\abc200202131500.dat

Can I use SPOOL "variable name" then build the filename as
file = ('abc' || to_char(sysdate,12) || '.dat')

thanks

 

[sjh7899]

i know you can input a parameter into the sql file that has a date value in it so im pretty sure you can do this.
if you try putting a parameter in the filename with a date value this would be the syntax

spool c:\schedule\abc&1.dat

by default if you dont put a file extension it will make a .lst file if you pass the parameter into the script like this

@script_name to_char(sysdate,12)

that should work but dont count on it because i use oracle 6i .
later Steve.

 

[sjh7899]

actually you need to have 2 dots before the file extension ie
spool c:\schedule\abc&1..dat

Steve