Home » SQL & PL/SQL » SQL & PL/SQL » how to create dynamic spool (oracle 8i)
how to create dynamic spool [message #311864] Mon, 07 April 2008 03:11 Go to next message
melvinRav
Messages: 43
Registered: April 2008
Location: India
Member
I have the following script

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 180
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
spool c:\test.txt
select * from emp ;
spool off
I want to create a dynamic spool name of the format allemp_dd_mm_yy.csv
wher the date is dependent on the sysdate

is there a way to create such a spool name of such a type

Re: how to create dynamic spool [message #311867 is a reply to message #311864] Mon, 07 April 2008 03:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please search BEFORE posting.

http://www.orafaq.com/forum/m/205454/102589/?srch=date+spool+file+name#msg_205454

Regards
Michel
Re: how to create dynamic spool [message #311868 is a reply to message #311864] Mon, 07 April 2008 03:30 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Google is your friend: check this link
Previous Topic: Last line truncated
Next Topic: hi I WANT 2 SEND MAIL WITH ATTACHMENTS USING PL/SQL
Goto Forum:
  


Current Time: Fri Dec 09 21:10:05 CST 2016

Total time taken to generate the page: 0.06972 seconds