I have a directory which contains a list of sql files,
I need to open each one of them in a loop
append text to the beginning of the file and end of the file.
Text in the beginning : Spool "file_name".log
Name of the file should be from corresponding file names.
Text in the end : Spool off
How can I do this.