Click to See Complete Forum and Search --> : Reports Question!!!


see_one
09-02-2004, 09:43 AM
Hi,

I want to know if there is way to save a report as a text file as you run the report. What I mean is, I run the report and I want the same report to saved in text file as it ran. I tried to play with system variables but couldn't figure it out. Any help or code would be appreciated. Thanks.

DaPi
09-02-2004, 01:06 PM
Is this SQL*Plus? If so:
SPOOL file_name
select . . . . . . .
SPOOL OFF

OOOOPS - I guess not :o