Shulou(Shulou.com)06/01 Report--

Use the spool command to copy the results of the output in sql*plus to a specified file, or to copy the results of the query

Send it to the printer until you use the spool off command directly.

The syntax of the spool command is:

Spool [file_name [create | replace | append] off | out]

Where file_name specifies an operating system file

Create will create a specified file_name file

Replace replaces the specified file if it already exists

Append appends the content to an existing file

Off stops copying the output from sql*plus to the file_name file and closes the file.

Out starts this function to copy the output structure from sql*plus to file_name.

Examples are as follows:

Then go to the contents of the a.sql file under / home/oracle

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.