creating spool file
i want to create a spool file everytime i login to my SQL
but it should not overwrite the previous file whenever i re-login to
is there any way to keep the previous spool file.
Three ideas spring to mind:
1) Use SPOOL filename APPEND to append to existing file
2) use HOST command to move the file to a backup location
3) Dynamically generate q unique filename via a SELECT statement and NEW_VALUE (maybe using a sequence?)
you can append sysdate to spool file and keep it better organised.
check the link for many ways to do:
"What is past is PROLOGUE"
Click Here to Expand Forum to Full Width