Oracle plsql output to file

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. We'll send a magic link to your inbox. Email Address. All Sign in options.

Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Sandeep saini November 17, 0 Comments. Thanks in advance. What is the problem with UTL file. Ed Edwards Posted November 18, 0 Comments. From what directory? Note that if you do not specify a file extension on the spool file name like.

Show 2 more comments. John D John D 2, 15 15 silver badges 28 28 bronze badges. I was gonna add the set pages 0 , set trimspool on , etc. But then the question changed and I had to chase down something else!

Good suggestions though. Shine Shine 3 3 silver badges 16 16 bronze badges. Mohamed Dernoun Mohamed Dernoun 3 3 silver badges 11 11 bronze badges. Having the same chore on windows 10, and windows server Dudi Boy Dudi Boy 2, 1 1 gold badge 11 11 silver badges 23 23 bronze badges.

It's better to spool inside the. Redirecting standard output to file may result in unwanted SQL feedback output in your file. Also, you could just quit or exit inside the. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. And of course, keep up to date with AskTOM via the official twitter account.

Question and Answer. Hi, I have the function which parse and create the csv file just like above code. But the challenge is I have more than 6 to 7 queries each of more than couple of of lines, what is the best approach to pass these queries to the function. I tried with bind variables but no luck. Moreover, I would like to automate this in a script file. Thank you in advance. Regards, Srikar.