Shulou(Shulou.com)05/31 Report--

Editor to share with you how to send the Oracle command output to the file how to write, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Set echo off

Set heading off

Set verify off

Set feedback off

Set show off

Set trim off

Set pages 0

Set concat on

Set lines 300

Set trimspool on

Set trimout on

Spool abc.sql append

Select 'FROM & 1. Position' from dual

Spool off

The above is all the contents of this article, "how to send the command output of Oracle to a file". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.