Hi, Your settings are fine. The last step is to split the spool and select statements into another script, as follows:. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy.
Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. Sign up using Email and Password. Post as a guest Name.
Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.
Related And of course, keep up to date with AskTOM via the official twitter account. Questions Spool file hide SQL statement. Question and Answer. The answer was useful. The SQl developer I find more comfortable. January 16, - pm UTC. Results 1 to 6 of 6. Join Date Feb Posts 3. SQL Plus Spool - I can't get rid of a trailing blank line in the output file Hi, I need to create a text file that is fixed format of characters.
I am not able to find a way to remove the 1 trailing blank line at the end of the output file. This is what I have now. I have tried several other set commands in various combinations, but still get the trailing blank line. Any help would be greatfully appreciated. Attached Files C2MapidUpdate.
0コメント