Oracle sql script output to log file

Here is sample of how-to-do must create table first as below and fix your loop control p. Register or Login. Welcome back!

Sign in with Email. Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign up with Email. Sign in with email Enter the email address associated with your account. This is the default behavior. Stops spooling and sends the file to your computer's standard default printer. This option is not available on some operating systems. Consider also using inside the script: set termout on and the spool command to further adjust the behaviour.

Refer to the Oracle sqlplus documentation for all the details. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Asked 3 years, 10 months ago. Active 3 years, 10 months ago. Asked 3 years, 10 months ago. Active 3 years, 10 months ago.

Viewed 6k times. Normally in DB2, if I want to execute a db script and output the execution result to a log file, I will do something as follow: db2 -tvf x. How about Oracle db? Kindly advise. Panadol Chong Panadol Chong 1, 10 10 gold badges 43 43 silver badges 88 88 bronze badges. Hi FrancescoB. I edited my solution. Currently on other project, probably will do it tomorrow. Add a comment. I wrote sql statement in shell script. Thank you very much.

Jim Oracle Certified Professional "Build your reputation by helping other people build theirs. I mean that I want to spool sql statement and output also. I assume this is a unix platform, I think the following is more what your looking for, create a unix file with execute permissions: Code:.